Copy Records from one DB to another.

J

John Keane

Hi,
I have an existing Access DB (Purchase.mdb) with one table
(tblPurchase). The first field is an autonumber type.

I have created an new DB (NewPurchase.mdb) with two tables
which are linked. The first table is 'tblOrders' which
has an autonumber on the first field and the second table
is tblOrderDetails which has a number type on the first
field. The tables are linked one to many.

I want to copy all the records for the first 10 fields
from the table 'tblPurchase' (in Purchase.mdb) to the
table 'tbOrders' (in NewPurchase.mdb) and the remaining 20
fields in 'tblPurchase' to the table 'tblOrderDetails' in
Newpurchase.mdb while keeping the records at the same
autonumber they have in the existing DB.

Any Help Welcome.

Regards

John Keane.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
How do I clear a form? 0
Copy selected records from two tables to two new tables 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Copy previous record into form field 0
Using list box adds blank record to lookup table 1
Autonumber records inserted in gaps 0
Copying table with Autonumber field 1

Top