Hello there

I am writing a program which will display data from an excel spreadsheet 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.

Maybe this link will provide the information you need:
http://www.connectionstrings.com/...

Regards