How to insert excel data to oracle database table using uipath

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

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.