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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
THANKS!!! worked perfectly.
Don


'69 Camaro said:
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
Click to expand...

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.
Click to expand...
 
Back
Top