Copying a table with DAO

[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

 

[Stuart McCall]

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

This (IMO) is the easiest way:

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