Using Excel As Database

News Knowledge Base
1

How to connect with Excel as a database ?

Perform the details mentioned in the Step by step guide, for connecting Excel as a database

  1. Open Excel file (Note - Excel file must remain open)
  2. In UiPath Studio Drag and drop Connect / Execute (Non) query activity
  3. Click Configure connection
  4. Open Connection Wizard
  5. Select Microsoft ODBC Data Source
  6. Use Connection String
  7. Click Build
  8. Go to Machine Data Source
  9. Click New
  10. Click Next
  11. Microsoft Excel Driver(.xls)
  12. Next
  13. Finish
  14. Give Some Data Source Name and Description --> Select workbook --> Select the particular excel file.
  15. Press Ok for all the Windows.

Attached is sample workflow, Excel file and screenshot of ODBC connection.

XAML File Download file
Spreadsheet Download file

4 Likes
2

A post was split to a new topic: Use mysql to retrieve data from the Excel into a data table

4

Hello @loginerror ,

Please note that the two links are not public.
I’m afraid that not everyone can retrieve the data.

Best regards,
Marius

2 Likes