I have two seperate databases. I want to append the data from one table into a similiar table in the other database. I wanted to do it with the TransferDatabase macro. Problem is everytime I try to append the data, Access creates a new table in the destination table instead of appending to the table I asked it to. Is there a way around this? Thanks