System Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello - I need to create a query (that exports to Excel) that includes system
info. I need the query to return the tables in the database, its columns, and
their data types and lenghts.

What is the best way to do that?

Thanks for the help
 
You need to write some code that will iterate the TableDefs collection. Then
within each TableDef, iterate its Fields collection. Read about these
objects, there are examples on this in the online help.

Ray
 
You must log in or register to reply here.

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

Report of Columns, their Data Types, etc. 1
Access Print Files from Query Results 0
Counting multiple memberships 1
column header needs symbol 2
Exporting query to table in external database 4
export crosstab query too many fields error 1
Access Query problem 1
Can't create a report from my query in Access 1

Back
Top