Hi
I have an excel workbook with 4 worksheets. When I connect to this workbook
using an Oledb connection, I use GetOleDbTableSchema to retrieve the names of
the worksheets ("TABLE_NAME"), only the schema table returns 5 rows, not 4.
If my worksheet names are Sheet1, Sheet2, Sheet3 and Sheet4, I would expect
to get 4 rows in the schema datatable, with "TABLE_NAME" as Sheet1$, Sheet2$,
Sheet3$ and Sheet4$, however, I get those four, and an extra one, say
Sheet1$_
Has anyone come across this before who could offer either an explanation, or
a solution, or preferably both?
Thanks in advance for your help.