ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ODBC/OLE DB to access Excel file and get weired table name Sheet$_ (https://www.excelbanter.com/excel-programming/306933-odbc-ole-db-access-excel-file-get-weired-table-name-sheet%24_.html)

Michael[_7_]

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