One sheet workbook, two TABLEs in schema

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using

GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing,
Nothing, Nothing, Nothing})

to get the names of the worksheets of my oledbconnection to excel 2003. In
some of the workbooks, there is only one worksheet, say Sheet1, yet it the
schema datatable, there are two rows marked TABLE, one called Sheet1 and one
called Sheet1_.

Could someone tell me why there are two tables listed in the schema when
there is clearly only one worksheet in the workbook?

Thanks in advance
GC
 
Back
Top