DoCmd.TransferDatabase (EXPORT)

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?
 
M

Maurice

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
 
Top