![]() |
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. |
All times are GMT +1. The time now is 05:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com