Re: Connecting to Excel

It should be "Extended Properties", not "Extended Property".

//------------------------------------------
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)


"Spencer Jago" <greenarmylee@xxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:44e6cfcf@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello there

I am writing a program which will display data from an excel spread***
in a DBGrid. The problem I am having is that at run time I am getting an
exception which says that it 'Could not find an installable ISAM'.

Any ideas?

I'm suspecting it's something to do with the connection string. It looks
like this:

strConn:='Provider=Microsoft.Jet.OLEDB.4.0;' + 'Data Source=' +
'C:\Fantasy 2007.xls;' + 'Extended Property=Excel 8.0;';

AdoConnection1.Connected:=False;
AdoConnection1.ConnectionString:=strConn;

I am using Excel 2002.

Any help would be great. Thanks.



.

Quantcast