I have two access databases. A and B
Both have a table with the same name (tbl_data entry) ie. same
structure/data.
I want to be able to transfer (export) data in this table from database A to
the same named table in database B - but i want the transferred data to be
ADDED to existing data already in database B.
I have tried the append query method but that simply REPLACES the existing
table data in B with the incoming data from database A.
I have tried creating a macro with the 'transferDatabase' action command
option - that too simply replaces the existing table data in database B.
I know that i can simply use the export function and rename the table that
transfers to database B. Then copy/paste the data to the required table.
But I'd rather have a transfer method that adds data (table data from
database A) to the existing table data in database B.
Appreciate any help on this.