Structure only (Access 2000)

Topic

New Reply

How shall i express by code the commands copy table paste structure only. I intend to use the following expression
Dim SQL As String
SQL = ” SELECT TblStudents.* INTO tblStudents FROM TblStudents
CurrentDb.Execute SQL
How can i set the requirement structure only ?

Reply | Quote

Replies

Instead of SQL, use DoCmd.TransferDatabase:

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

The last argument True specifies that you want to transfer the structure only.

Reply | Quote

Thank you for that. I immeditely tried it with success !

Reply | Quote