Transfer Database macro creating duplicate table

[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

 

[Jerry Whittle]

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.