How to copy a table structure using code

[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 !

 

[Graham R Seach]

DoCmd.TransferDatabase acExport, "Microsoft Access", _
CurrentDb.Name, acTable, "tblMyTable", "tblMyNewTable", True

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

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.