View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucia[_2_] Lucia[_2_] is offline
external usenet poster
 
Posts: 1
Default help: extracting Execel tables with ADO without reordering them

I'm trying to find a way to extract all the worksheets
(tables) from an Excel workbook and having them returned
in the same order in which they're originally defined in
the workbook (not alphabetically).

The VB.net instruction used is:

tables = ccn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _
New Object() {Nothing, Nothing, Nothing, "TABLE"})


Is there any other way (like query, etc.) to get all the
tables?

Thanks,
Lucia