Unable to connect to Excel as DB- External table is not in Expected Format

I am unable to connect to Excel as DB- getting the below error-

I get this error if i add a new column for updation.

This is the connection string - Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$sProcessFilePath$;Extended Properties="Excel 12.0 Xml;HDR=YES";

Cadet | Tier 2

Yes I tried.

I tried using Excel Open - Get multiple cells - Write from data table to new excel -

The new excel gives same error using Excel as DB connect action.

Now also getting error while trying to open Excel Advanced: Open Action

Are you able to open the new Excel file manually after writing data from the data table?

Yes, there is no issue in opening excel manually. The issue is with the connecting using Excel as DB

Navigator | Tier 3

Hi @Hasna Nizam ,

Can you please try to repair the Microsoft O365 Apps from Control Panel and reinstall the Access 2016 Runtime.

This troubleshooting may resolve the issue.

Thanks

Narendra Guptha

Sign up