Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reading tables in Excel

Status
Not open for further replies.
calculus

calculus

Programmer
Apr 10, 2003
390
US
Hope this is the right place to ask this.

I'm trying to read/write to Excel. I've been able to accomplish this with ADO, but now I need to enumerate the tables in a file.

I found docs on:
adoConn.OpenSchema (adSchemaTables)
but every time I run this on any other variation, I get an error saying the object doesn't know this method (or something to that effect).

Any ideas?

calculus
 
Status
Not open for further replies.

Similar threads

dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
497
dcern
dcern
Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
476
Vary88
Vary88
Malbordio
  • Locked
  • Question
ODBC in PHP to connect to ServiceNow
Replies
1
Views
538
k5tm
k5tm
brk1221
  • Locked
  • Question
ODBC connection from Windows to IBM Informix
Replies
3
Views
615
genomon
genomon
PerlIsGood
  • Locked
  • Question
MDX Dynamic Set not showing up in cube
Replies
0
Views
103
PerlIsGood
PerlIsGood

Part and Inventory Search

Sponsor

Back
Top