CopyObject When Destination File Might or Might Not Exist

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hi,

Can you tell me how I can copy an Access table to a different name, say
Table2 when there is possibly (or possibly not) already a Table2 and I want
to write over the old Table2 if it exists?

Thanks
 
Charles said:
Hi,

Can you tell me how I can copy an Access table to a different name, say
Table2 when there is possibly (or possibly not) already a Table2 and I
want
to write over the old Table2 if it exists?
Click to expand...


You can use the TransferDatabase method instead of CopyObject. For example,

DoCmd.TransferDatabase acExport, _
"Microsoft Access", CurrentDb.Name, _
acTable, "Table1", "Table2"

.... will copy Table1 to Table2 in the current database, replacing Table2 if
it exists.
 
Back
Top