0
00KobeBrian
How can I export the table name in a mdb to an excel file? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Martin
DoCmd.TransferSpreadsheet
0
00KobeBrian
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.
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.
0
00KobeBrian
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.
0
00KobeBrian
D
Douglas J Steele
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]
to query the system catalog:
SELECT [Name]
FROM MSysObjects
WHERE Type In (1,4,6)
AND Left([Name], 4) <> "MSys"
ORDER BY [Name]