Connecting Excel file via ADO.

• mahesh balshetwar

  SSC Veteran

  Points: 273

  More actions

  October 13, 2003 at 6:02 am

  #66147

  Hello,

  I have problem of making connection to the Excel file with the following connection string...

  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Test.xls;Extended Properties=Excel 8.0;"

  In the above connection string version is hadwired and so I changed it to....

  .Provider = "MSDASQL"

  .ConnectionString = "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & strWebFilePath & "; ReadOnly=False;"

  but I am still facing the problem. The following error I get when I try to make ADO connection to the Excel file....

  Microsoft OLE DB Provider for ODBC Drivers error '80004005'

  [Microsoft][ODBC Excel Driver] External table is not in the expected format.

  Can anybody please help me in finding the solution please.

  Phill,

  I file is created in Office premium. Does that make difference??

  Regards,

  Mahesh

• rs

  SSCrazy

  Points: 2819

  More actions

  October 13, 2003 at 11:00 am

  #478031

  Try This .............

  Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strWebFilePath & ";Extended Properties="""";Excel 8.0;HDR=Yes;"

  Conn.Mode = adModeReadWrite

  Conn.Open

• mahesh balshetwar

  SSC Veteran

  Points: 273

  More actions

  October 14, 2003 at 5:45 am

  #478116

  Hello All,

  the problem is in the file and from error itself we should understand that the given file is not a Excel file because it says External table is not in the expected format. Thanks all for your help.

  Regards,

  Mahesh