TransferDatabase

[mugman17]

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

 

[S]

Try to Inport (appending it) in the source database the destination table and run an "appending query" to copy records from source table to appended table; it will be works.
Bye, S.