table name question

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
0

00KobeBrian

How can I export the table name in a mdb to an excel file? Thanks.
 
Sorry. This is not what I want. I mean to say if there are 50 tables in an
access mdb and I want to have them on an excel spreadsheet, how can I export
them automatically instead of typing the 50 table names in excel
spreadsheet? Thanks.
 
Something like data dictionary.

00KobeBrian said:
Sorry. This is not what I want. I mean to say if there are 50 tables in an
access mdb and I want to have them on an excel spreadsheet, how can I
export them automatically instead of typing the 50 table names in excel
spreadsheet? Thanks.
Click to expand...
 
You mean you want a list of the tables in your database? The easiest way is
to query the system catalog:

SELECT [Name]
FROM MSysObjects
WHERE Type In (1,4,6)
AND Left([Name], 4) <> "MSys"
ORDER BY [Name]
 
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

Create a file 2
VBA - retrieve data on last create named range from previous inserted named range 0
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
Update Two Tables Using One Form Contents 0
There Must Be Some Way ???? 0
Selection Criteria with Combo Boxes 1
How to Export Gmail Emails to PST Format? 4
Name of table and query to be more understandable 1

Back
Top