How to copy records from one table to another in another DB

[donsql22222]

I have 2DBs with identical tables. I want to take a block of records from
table1 in DB1 and add them to table1 in DB2 after first deleting them which
has been done.
I've tried creating a table from a query of the record set and then exported
it to a CSV file and then tried to import that to DB2.
I get "Invalid argument".

Any suggestions appreciated.

Don
Access 2003

 

['69 Camaro]

Hi, Don.

I have 2DBs with identical tables. I want to take a block of records from
table1 in DB1 and add them to table1 in DB2

Have you tried an append query into the remote database (DB2.mdb in the
following example)? Try:

INSERT INTO [;DATABASE=C:\Work\DB2.mdb;].tblSuppliers
SELECT *
FROM tblSuppliers
WHERE Category = 'Adhesives'
ORDER BY SupID;

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[donsql22222]

THANKS!!! worked perfectly.
Don

Hi, Don.

I have 2DBs with identical tables. I want to take a block of records from
table1 in DB1 and add them to table1 in DB2

Have you tried an append query into the remote database (DB2.mdb in the
following example)? Try:

INSERT INTO [;DATABASE=C:\Work\DB2.mdb;].tblSuppliers
SELECT *
FROM tblSuppliers
WHERE Category = 'Adhesives'
ORDER BY SupID;

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.