DoCmd.TransferDatabase (EXPORT)

  • Thread starter Thread starter MJ
  • Start date Start date
M

MJ

When using this command to create a copy of an existing table into another
database, what happens if the table already exists in the destination mdb?
1) Does it append to existing table (without creating duplicates of
existing records)?
2) Does it add it to the already existing table (potentially creating
duplicates of existing records)? OR
3) Does it overwrite the existing table?

Thank you for your assistance?
 
Data doesn't get appended because you are transferring an object. So my guess
would be that you would get a notification that the table already exists or
you would get a duplicate with a 1 appended to the name (something like
table1)

hth
 
Back
Top