Copy table structure only (Access 2000)

Topic

New Reply

I need to use in a function copying a new table structure only, exactly as when i do it manually with copy,paste,and select structure only.Can i do it by code ?

Reply | Quote

Replies

You can use DoCmd.TransferDatabase to “import” the table into the current database; TransferDatabase has a StructureOnly argument:

DoCmd.TransferDatabase acImport, “Microsoft Access”, CurrentDb.Name, acTable, “tblStudents”, “tblNewStudents”, True

will copy the structure of the table tblStudents to a new table tblNewStudents.

Reply | Quote

Thank you so much

Reply | Quote