Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC/OLE DB to access Excel file and get weired table name Sheet$_
I have a customer file, which contains a sheet named 'Sheet1'. I used ODBC
driver and OLE DB with jet provider to access the file. In both cases, I got two table names returned to me. One is 'Sheet1$' as I expected. And the other is 'Sheet1$_' which I would like to know where it came from ? I got an in-existing table message when I tried to query the 'Sheet1$_' table. JSince et engine returned me the table and why it told me the table does not exist when I queried it ? Thanks. P.S. Mail me please if you need to take a look at the file. I have created a very small excel file for this testing purpose. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel doing some weired stuff | Excel Discussion (Misc queries) | |||
Link an excel sheet to access table with pics | Excel Discussion (Misc queries) | |||
Pivot Table - ODBC Link to Access db | Excel Discussion (Misc queries) | |||
how to access databases from excel using ms query and odbc? | Excel Discussion (Misc queries) | |||
Appending Excel file to an Access table | Excel Programming |