Access 2002 - duplicate databases

[Guest]

I have a membership database that I update for a small non-profit. I had
made a copy of it when I was moving some files and forgot to delete it. My
problem is that I entered about 50 records into the copy and not the master.
Is there a way to merge the records into the master database? If so please
point me to detailed instructions as I am a newbie and need a little hand
holding.

Thank you

 

[Guest]

Hi Carol

I have to do this sort of thing often as I have a db that can't operate
across the network and I therefore have to 'xfer' records weekly. You do
this by: Go to your old database and create a query that selects only the 50
records you want - export the records [using the File, Export menu options]
as an excel file to your desktop. Then import the file using the File, Get
External Data and follow the import wizard. Good Luck

PS - [If you have an autonumber primary key in your table - you'll have to
do a two step process of importing the file into a NEW table and then copying
and pasting the records to your existing table. Just make sure the columns
are identical when you do this copy and paste]

--Sue Compelling

 

[christiane debue]

Export the table in the copy (rename it when dialog box appear) to master.
Then use Append Query to append the 50 records to your master table.
Hope can help!

MaChii