Export Table Design

[cw]

I need to duplicate some Access tables in another db. Is there a way to
export the table design (ie. Field Name, Data Type and Description)?

Thanks

 

[Jeff Boyce]

Push or pull...

You can push the tables' structure to another db using Export.

You can open the new db and Import the table structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[cw]

This recommendation seems to only export table data in a format specified in
the save as selections. I need a to create an identical table schema in
Oracle and MySQL so I don't see how Export will accomplish this.

 

[Jeff Boyce]

I don't recall seeing any mention of Oracle or MySQL before...

Have you tried opening them and using their "data transform" or "import"
facilities to create a schema? Do you have the permissions to do so in
those dbs?

Regards

Jeff Boyce
Microsoft Office/Access MVP