Move records to another DB

bmwilson · Dec 13, 2001

Can someone help me with exporting a record from one table in one database (database 1), to a table in another database (database 2).

I need it to run when a command button is pressed. I would prefer to perform this action from database 1 (to export it into database 2), but the reverse would be ok too.

I would prefer not to link the 2 databases but if it cant be done then too bad for me.

Regards
Ben

prycejones · Dec 14, 2001

Use an append qry and use IN for the name of the database
Your SQL code should look something like this

Code:

INSERT 
INTO customers IN "c:\database2.mdb"
yaah dee yaah...
FROM customers IN 'C:\database1.mdb"
WHERE Customer = '...etc etc      ;

hth
pryce

Move records to another DB

bmwilson

Registered User.

prycejones

New member

Similar threads

Users who are viewing this thread