Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    1

    Unanswered: Using Excel with Delphi

    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.

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Maybe this link will provide the information you need:
    http://www.connectionstrings.com/...

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •