How to make connection between uipath and excel to get data of excel from sql command

How to make connection between uipath and excel to get data of excel from sql command

Hi @kumarshantanu

Use connect activity

And execute non query
Use the statement as “select * from table_name”

Or if you want to insert

Use insert activity
Pass the datatable

Thanks
Ashwin.S

Hello @AshwinS2,

I have been struggling to find the solution for the above from last 1 week how to insert my excel data to sql tables. Is it possible for you to share the workflow? I did the same as suggested by you but it’s always giving me error!

Any help would be appreciated!

Thanks Vaibhav