Access database to database table transfer

Question

Hi all,

I'm trying to transfer data from one access db table to a different access db table. Both source and target tables have the same structure. The code successfully imports the data from the source table into the current db BUT it puts the data into a NEW table instead of importing the data into the target table.

DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\SourceDBFileName.accdb", acTable, "SourceTableName", "TargetTableName"

If any one can help point out what I am doing wrong, I would be very thankful!

Thanks!

Answer 1

Very odd. Maybe you edited the OP? It used to say:

DoCmd.TransferDatabase, acImport, "Microsoft Access", "TargetDatabaseName.accdb", acTable, "C:\SourceFolderName\SourceFileName.accdb", "SourceTableName", "TargetTableName"

Answer 2

You may need to link to the table and run an Append query.

Answer 3

Thanks Tom for the response!

I don't have a comma after the word "DoCmd.TransferDatabase".

Also I meant to clarify that the reason I want to transfer the data from db.SourceTable to db.TargetTable INSTEAD of just importing the tables is because there are other fields in the TargetTable that I have added or changed attributes on. The source tables do not have these new fields. I just want to transfer the data from the fields that are common to the 2 tables.

Hope that makes sense!

Thanks!

Answer 4

Remove the comma after TransferDatabase.