ADO properties for Excel Information

How can I get the names of an Excel workbook's Worksheets into an ADO recordset via an ODBC connection?

Does the Excel ODBC driver support schema type properties to accomplish this?

Any suggestions on getting the Worksheets Collection into an ADO recordset would be appreciated.

Thanks
LoggerheadAsked:
Who is Participating?
 
trnarahariConnect With a Mentor Commented:
Use ADOX Catalog, Table, Column Objects to get the Complete Information about WorkSheets in a Workbook and also columns in a each of the Worksheet.
0
 
d_glennCommented:
Learning . . .
0
 
Richie_SimonettiIT OperationsCommented:
There is another question similar to this.
I think ODBC doesn't provide that but may i wrong.
0
 
DanRollinsCommented:
Hi Loggerhead,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept trnarahari's comment(s) as an answer.

Loggerhead, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.