Re: Connecting to Excel

Jago,

Here's how to use ADO to Read/Write to XLS files:
http://delphi.about.com/od/database/l/aa090903a.htm

~Zarko Gajic

"Spencer Jago" <greenarmylee@xxxxxxxxxxxxx> wrote in message
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