Outputting table from one DBase to another

[robertlevine]

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]

Use the TransferDatabase method and ensure structure only is set to yes.

 

[MsLady]

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.