469,159 Members | 1,453 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

Export Table Design to Excel

Hi,

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

Thanks,
Laura
May 23 '08 #1
4 27050
nico5038
3,080 Expert 2GB
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)
Attached Files
File Type: zip TableFields.zip (16.3 KB, 3391 views)
May 24 '08 #2
ADezii
8,800 Expert 8TB
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
May 24 '08 #3
@nico5038
Excellent post/function! This was a real lack in Access, but yu fixed the problem. Thanks!
Jan 18 '13 #4
@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 PMOLEADER@gmail.com, and phone # 1226-505-2896
Aug 9 '21 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Matt | last post: by
4 posts views Thread by Hans [DiaGraphIT] | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.