How to make connection between uipath and excel to get data of excel from sql command
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
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!