Copying a table with DAO

  • Thread starter Thread starter vsoler
  • Start date Start date
V

vsoler

In my small application, I need to copy tblTableA into a new
tbltableB, structure + contents. How can I do this using the DAO
object Model in VBA?

thanks for any help
 
vsoler said:
In my small application, I need to copy tblTableA into a new
tbltableB, structure + contents. How can I do this using the DAO
object Model in VBA?

thanks for any help
Click to expand...

This (IMO) is the easiest way:

DoCmd.TransferDatabase acExport, "Microsoft Access", _
CurrentDb.Name, acTable, tblTableA, tbltableB, False
 
Back
Top