How can we connect with excel as a database ?
Step by step guide
- Open Excel file (Note - excel file must remain open)
- In UiPath Studio Drag and drop Connect / Execute (Non) query activity
- Click Configure connection
- Open Connection Wizard
- Select Microsoft ODBC Data Source
- Use Connection String
- Click Build
- Go to Machine Data Source
- Click New
- Click Next
- Microsoft Excel Driver(.xls)
- Give Some Data Source Name and Description --> Select workbook --> Select the particular excel file.
- Press Ok for all the windows.