Transfer Database macro creating duplicate table

  • Thread starter Thread starter Rachael
  • Start date Start date
R

Rachael

I am trying to transfer a table from Database A into Database B using a
macro. The macro (located in and run from Database B) first runs a delete
query that deletes the existing records in TableB in Database B.

Next, I use the transfer database command in the macro to import TableA in
Database A into the now empty TableB in Database B.

Rather than simply placing the records from Table A into Table B, the macro
is creating a new table in Database B, called Table B1. I've checked
everything I know to check. Am I doing something wrong, or is there a better
way to accomplish this?

Thanks, Rachael
 
Instead of transferring the table from A, link to that table in Database B.
Then use an append query to copy over the records from A to B.
 
Back
Top