How to export data structures from MS Access 2000

[Wilson Hew]

Anyone knows how to export data structures from MS Access 2000? I want to export field name, field type, field size, remarks from the structure. No records are required! Does it possible? Please help!

Wilson

 

[Wilson Hew]

I know how to do it! Tools menu --> Analyzer --> Documenter. Select the necessary tables to be printed out. That is!

Wilson

 

[yippie_ky_yay]

Hey Wilson,

are you sure you got the answer you were looking for?

If you only want to export a table and don't need the records, just go to File -> Export. Then select your target (be it an Excel workbook or another access database - you need to have one ready to accept it!), and select "Definition only".

Hope that helps!

-Sean