Thread: ADO - Excel - External table is not in the expected format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adriana Camargo Adriana Camargo is offline
external usenet poster
  
Posts: 2
Default ADO - Excel - External table is not in the expected format

I copied the data into a new file, and then it works fine.
Im using some others files that work fine.
The error ocurr just when the program tries to open the connection to
the file.

If somebody can give me a hint?

This is the code that i used to open the excel file.

strExcelConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;data source=" & strFileName &
";Extended Properties=""Excel 8.0;HDR=No;IMEX=1"""

cn.ConnectionString = strExcelConnectionString
cn.Open

Thanks!!!



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote