[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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
0
Loggerhead
Asked:
Loggerhead
1 Solution
 
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
 
trnarahariCommented:
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
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now