Google Answers: How can I create a list of all tables and fields visible in an ODBC connection?

View Question

Q: How can I create a list of all tables and fields visible in an ODBC connection? ( No Answer, 0 Comments )

Question

Subject: How can I create a list of all tables and fields visible in an ODBC connection?
Category: Computers > Programming
Asked by: aidan321-ga
List Price: $20.00

Posted: 18 Sep 2006 11:40 PDT
Expires: 18 Oct 2006 11:40 PDT
Question ID: 766327

I am looking for a piece of vba coding for Access 2000 that will take
the name of any defined odbc connection and a user login, and then
create an excel or table output that will list all available table
names and their fields.  The hope is to create a tool that will allow
user-side mapping.

For example...

Parameters:
Data source name - "Source" 
User - "Someone"
Password - "pword"

Output:

TableName1                  Field1
TableName1                  Field2
TableName1                  Field3
...

Answer

There is no answer at this time.

Comments

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy