How can I use Excel as a source in my database activity?
At the moment of writing this content, the latest version of the UiPath.Database.Activities package is 1.7.1 and the instructions apply to it and the previous versions.
- Open any Excel file (it does not have to be the file planned to be used as a source)
- Given that the Database package is already added to the project, use the "Connect to database" activity
- Click "Configure connection" -> Connection Wizard
- From "Data source", select "Microsoft ODBC Data Source"
- From the "Details" section, select "Use connection string" and click "Build"
- Go to the "Machine Data Source" tab
- Click New
- Click Next
- Select Microsoft Excel Driver(.xls) from the menu
- Next
- Finish
- Give Some Data Source Name and Description --> Select workbook --> Select the Excel file you intend to use as source.
- Press "OK" for all the Windows.