How to Use Openschema ?

  • Thread starter Thread starter Stan Sainte-Rose
  • Start date Start date
S

Stan Sainte-Rose

Hi,
I would like to read all the tabs stored in a Excel sheet.
How can I do this with Ado.net (vb.net).
I suppose I have to use the OpenSchema method, but I can't see how (I used
to do it with ado).

Thanks for your help
Stan
 
¤ Hi,
¤ I would like to read all the tabs stored in a Excel sheet.
¤ How can I do this with Ado.net (vb.net).
¤ I suppose I have to use the OpenSchema method, but I can't see how (I used
¤ to do it with ado).
¤

Not sure if I understand your question. Are you saying that you want to list all of the Worksheets
in an Excel Workbook?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i use OpenSchema? 1
Get User List from Access MDB 4
Can I get the fields in an Access table using just an SQL statement? 2
OpenSchema on workbook reveals strange table 1
Description Filed 2
DAO to ADO 13
Access database: How to set Isolation Level using System.Data.OleD 4
How to detect if a Sproc exists ? 4

Back
Top