Could not find installable ISAM

Question

I am using vb.net 2003 and I want to read Excel 2003 using OleDb Connection. But I have a problem when I put the IMEX=1 property in the connection string. But when I need to create this IMEX property, the system will work without errors. Here is my connection string

 xlsCon = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & pathName & " ; Extended Properties=Excel 8.0;IMEX=1") 

Can someone help me on how I can fix this error? I need to put the IMEX property so that it tells the driver to always read the mixed (string, integer, date) data type in each cell.

Here is the error I encountered.

 System.Data.OleDb.OleDbException: Could not find installable ISAM. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Production_Tracking_System.frmPMEFNATUpload.getUploadedData(String pathName) in D:\Legacy\Development\PTS 2 VSG-NAT\Forms\frmPMEFNATUpload.vb:line 434 

Answer 1

If you use more than one extended property, then value tokens must be specified, otherwise the driver will not be able to distinguish them from other non-extended properties in the connection string;

 ... pathName & ";Extended Properties=""Excel 8.0;IMEX=1"""