Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table in design mode to Excel (2003)

    I need to document all my work and I have told to take the table and see if I can move/copy the fields just the way it looks into MS Excel. I am refering to the table in design mode. Anybody know how to do something like this?

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table in design mode to Excel (2003)

    Access has a documentor feature under the Tools Analyze that will give you reports with this information for printing. Lots of choices at to what data you want see.

    Carla

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Table in design mode to Excel (2003)

    Attached text file is exported code module with example of a procedure (ExportTableDesign) that will loop thru all tables in current database (excluding system tables, linked tables, etc - can modify as desired) & export field names, data type, size, and description to an Excel file. Each table is exported to a separate worksheet. If additional descriptive data required, code can be modified accordingly. I tested this using Access/Excel versions 2000 & 2003 and worked OK. Note - requires reference set to DAO 3.6 & Excel (applicable version) object libraries.

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •