How to copy a table structure using code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2002 and need to find out how to copy a table structure ( the structure only, not the data) using code. I tried the docmd.CopyObject command to copy the table but it also copies the data too, but I only want the table structure itself

Any help on this would be greatly appreciated !
 
DoCmd.TransferDatabase acExport, "Microsoft Access", _
CurrentDb.Name, acTable, "tblMyTable", "tblMyNewTable", True

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

lab said:
I am using Access 2002 and need to find out how to copy a table structure
Click to expand...
( the structure only, not the data) using code. I tried the
docmd.CopyObject command to copy the table but it also copies the data too,
but I only want the table structure itself.
 
Back
Top