Oledb connection:.xlsx file: Could not find installable ISAM Error?

I’m using SSIS package to export some data to a .xlsx file as given below:

1)      Using Oledb connection manager

2)      MS ACE provider (Tried Jet OLEDB provider as well. It gives invalid UDL file error in this case)

3)      Extended properties as “Excel 12.0 Xml;HDR=NO;IMEX=1” (Tried Excel 8.0 and Excel 8.0 Xml as well).

When I do Test connection it gives an error “Could not find installable ISAM”.

Recently I’ve installed “MSExcel 7.0” as well in case the error has anything to do with dlls related to Excel7.0.

Answer:-

Try this one, hope it may help in solving your problem.

For .xlsx extension use this connection string           

{

                        connection string = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + stringFilePath + "; Extended Properties=Excel 8.0;"; (HDR=Yes and IMEX=1 is optional)

                        }

                        For .xls extension use this connection string

                        {

                        connection string = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + stringFilePath + "; Extended Properties=Excel 8.0;"; (HDR=Yes and IMEX=1  is optional)

                        }

Provide your comments plz!.

Tweet