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.
|