Move records to another DB (1 Viewer)

bmwilson

Registered User.
Local time
Today, 13:37
Joined
Dec 6, 2001
Messages
18
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

New member
Local time
Today, 13:37
Joined
Dec 14, 2001
Messages
3
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
 

Users who are viewing this thread

Top Bottom