How to insert excel data to oracle database table using uipath

Learn Academy Feedback
, , ,
1

Hi guys,

I have oracle database , i need to store my excel data to oracle database table via uipath

Please anyone help this.

Regards,
Raja G

1 Like
2

Hi @Raja.G,

Are you trying to insert the data to a Oracle database? If so you will first need to install the appropriate driver to connect to the database. Once that is done, you can follow the below steps.

  1. Add UiPath.Database.Activities to your UiPath solution through package manager.
  2. Add a Read Range to read your excel to a datatable
  3. Use the database connection activity and create the connection to the database
  4. Use a for each row activity to loop through the datatable
  5. Within the loop, use the execute query activity.
  6. Configure this activity to accept the datarow returned from the row variable of the for each row.
  7. Write the query to insert it into your table

Hope this helps,

Regards,
Neelima.

3

any update for your request , because i need the same your request ? , please if you found a solution share with me , thank you