View Full Version : Outputting table from one DBase to another


robertlevine
06-29-2004, 07:56 AM
I'm looking to output an entire table from one Access 97 database to another. I do not want to copy data from one table in one database to another table in another dbase.

I want a table created in the 2nd database with the same name/data of the 1st.

Anyone know how to do it?

Mile-O
06-29-2004, 08:22 AM
Use the TransferDatabase method and ensure structure only is set to yes.

MsLady
07-02-2004, 04:10 PM
or go to the database you want to transfer table/data from,
Goto File menu -> export (select the database you want to export into), Export dialogue box should open (ensure that "export data/definition" option is selected. Click Ok. and you should have it.