Copying data from one DB to another

[Christiana]

I was given a database where all the information was saved in a single table. For faster quering and upgrading I have split in multiple tables. Now I want to copy the information from the tables of the first DB to the others accordingly.

What is the easiest way to do this? Pls help

X-)

 

[PaulF]

Link the original table to the new database, and use Append, Update or MakeTable queries to add the info.

PaulF

 

[ghubbell]

From the database window of your new database:
File-Get External Data - Import
and choose the database you wish to import from, then select the tables you need! Gord
ghubbell@total.net