Export Table Design to Excel

[redcali55]

Hi,

Is it possible to export the design of a table to Excel (e.g. Field Names, Data Types, Descriptions)?

Thanks,
Laura

[nico5038]

Hi,

Is it possible to export the design of a table to Excel (e.g. Field Names, Data Types, Descriptions)?

Thanks,
Laura

For this I use a small function and a table to store the result in. That table can be used to copy/paste or export to excel.

Just check the attachment, place the tables and the module in your database and run the function by placing the cursor in the code and pressing F5.

Nic;o)

[ADezii]

Hi,

Is it possible to export the design of a table to Excel (e.g. Field Names, Data Types, Descriptions)?

Thanks,
Laura

Is it possible to export the design of a table to Excel (e.g. Field Names, Data Types, Descriptions)?

Here is one Method, but you'll have to clean up the Spreadsheet:

1. Tools ==> Analyze ==> Documenter
2. Select Tables Tab ==> check the Table(s) you wish to document
3. Click on the Options button
4. Select the specific Table Definitions to document ==> click OK
5. Click OK in the Documenter Dialog Box
6. Once the Object Definition Screen appears:
   1. File ==> Export ==> Save as type = Microsoft Excel (*.xls)
   2. Set Options for Save in and File name
   3. Click the Save button
7. Let me know how you make out

[armckelv]

@nico5038
Excellent post/function! This was a real lack in Access, but yu fixed the problem. Thanks!

[asadullahmalik]

@nico5038
Hi Nico, I am facing trouble to use the solution offered by you. Can you please elaborate the steps in a bit more detail, or if you do not mind then contact me via email/phone to apply your solution? My email is [e-mail], and phone # [phone]