UiPath: Manipulate Excel with SQL
Working with Excel in RPA world is something that we all need to master.
With this video you add additional knowledge for manipulating excel data.
This method can be adjust to work with "csv" and "xls" files.
Here are some useful links that you may need for the execution of this tutorial:
Excel connection strings: https://www.connectionstrings.com/excel/
In case of "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" error: https://www.microsoft.com/en-us/downl...
For more tutorials about RPA don't forget to subscribe!!!
