Export questions.

  • Thread starter Thread starter KT
  • Start date Start date
K

KT

I want to set up a macro that would export the tables from my
database(A db) to another database(B db). What i want to do is to
append those data to tables that are already in the B db without
replacing them. Is it possible?

I tried the TransferDatabase Macro, but it said I can't delete the
tables because they are within a relationship..so seems that the
TransferDatabase Macro was trying to replace the table.


Any help will be appreciated! Thanks a lot!

Kanley
 
You need to use OpenQuery action to run an Append Query (or RunSQL action to
run an Append SQL) instead of the TransferDatabase action.
 
Thanks Van. By running OpenQuery action in Database A, can I append
data to a table in Database B? Or do I need to run this in Database B
for that?

Thanks a lot!

Kanley
 
Yes you can. You need to use the IN Cluase in the Append Query to point JET
(the database engine) to the Destination Table in another database.

Check Access Help (JET Reference section) for the In Clause.

--
HTH
Van T. Dinh
MVP (Access)
 
Back
Top