how can i export a list of table names from an access 2003 db to an excel file? thanks. - Parth
P parth Mar 21, 2007 #1 how can i export a list of table names from an access 2003 db to an excel file? thanks. - Parth
D Douglas J. Steele Mar 21, 2007 #2 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]
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]
