File Path contains invalid Excel file. Please provide file with .xls or .xlsx

If you’re trying to wire up to Excel using a file extension other than .xls or .xlsx, you may get one or more of the the following errors:

File path contains invalid Excel file. Please provide file with .xls or .xlsx extension.

Test connection failed because of an error initializing provider. Could not find installable ISAM.

Test connection failed because of an error in initializing provider. Unrecognized database format ‘filename’

When I tried for the first time to connect I was here:

Simply connect to an OLE DB source and not an Excel file, and set a couple of properties and you should be gold.

If you reverse the order of the HDR and the Excel 12.0 format in the “Extended Properties” box, it gives you an error, so do it in the order that I have, above.

Thanks for reading,

Lee Everest

---------------------------

The SQL Police should have no problem with this post…I think.