Re: Could not find installable ISAM

Try include HDR into Extended Properties, it is not separate parameter:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
E:\Personnal\xcelfiles\GROCLST.XLS;Extended Properties="Excel 8.0;HDR=YES;"

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Terry" <cooleyt@xxxxxxxxxx> ???????/???????? ? ???????? ?????????:
news:43de8cea$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Attempting to open an excel spread*** using ado with the following
> connectstring:
>
> 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
> E:\Personnal\xcelfiles\GROCLST.XLS;Extended Properties=Excel 8.0;HDR=YES;'
>
> results in the following error:
> OEleException message 'Could not find installable ISAM'.
>
> Thanks for any help.
>


.