Connecting to Excel

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