| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External table is not in the expected format. | Excel Discussion (Misc queries) | |||
| DATE FORMAT IN PIVOT TABLE FROM EXTERNAL DATA SOURCE | Excel Discussion (Misc queries) | |||
| Pivot Table Wizard Error (Expected 52) | Excel Discussion (Misc queries) | |||
| LOOKUP function not returning expected value - Using vector_lookup format | Excel Worksheet Functions | |||
| external database to view in EXCEL format | Excel Discussion (Misc queries) | |||
Threaded Mode
