Excel as Datatable

[monish06 (monish)]

Hi,

When I try to connect as local excel file as DB, am getting following error message as “External Table is not expected in the following format”. Please let me know did I miss anything.

@Palaniyappan

[Sharanabasava1 (Sharanabasava)]

Did you find any solution?

[Gokul_Jayakumar (Gokul Jai)]

@monish06 Please refer to this

Using Excel As Database

How to connect with Excel as a database ? Perform the details mentioned in the Step by step guide, for connecting Excel as a database 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) Next Finish Give Some Data Source Name and Desc…