TransferDatabase Action in Macros

[KrazyKT]

I have created a macro in order to transfer four tables on information to another database with the same four tables.&nbsp;&nbsp;I will have numerous tables to add to this database.<br>I used the transferdatabase action and it worked.&nbsp;&nbsp;How do I get it from overwriting the information in the destination database?&nbsp;&nbsp;Do I need to write an additional macro in the destination database or the one I'm exporting from?&nbsp;&nbsp;Or is there an action I need to add to the macro I am currently using to transfer the tables?

 

[famousb]

if both databases already have the same tables, and you just want to add records without overwriting, then you are better off using Append Queries (or equivalent SQL).&nbsp;&nbsp;then you can create a Macro to run all of the queries, or just a few, or whatever. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>