Access 2002 - duplicate databases

C

CarolM

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
 
S

Sue Compelling

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
 
Top