Export list of table names to an excel file

P

parth

how can i export a list of table names from an access 2003 db to an
excel file?
thanks.
- Parth
 
D

Douglas J. Steele

Try creating the following query, and export it:

SELECT [Name]
FROM MSysObjects
WHERE Type In (1,4,6)
AND Left([Name] , 4) <> "MSys"
ORDER BY [Name]
 

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

Export to Excel 3
keeping "#" in the column names when exporting to Excel 4
Import to many to many table 7
Export to Windows SharePoint Services only works once - why? 1
Export to Excel more than 900,000 records 2
Export query to Excel fails 6
Exporting a table from Access 2003 to Excel 2007 1
Simplified table creation 2

Top