Table in design mode to Excel (2003)

Topic

New Reply

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?

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote