Copy Access Table Structure to a New Table DAO

[Trob70]

I need to Create a new Table in an Access Database Copying the Structure of an existing Table
The sql i have created is..


Dim db As DAO.Database
Dim MyQry As DAO.QueryDef
Sql = "CREATE TABLE Data2 AS SELECT * From Data1 WHERE 1= 2"

Really appreciate some help with the above code .

Regards Trob70

 

[Trob70]

All ok Have worked it out...

Sql = "SELECT * INTO Data2 FROM Data1 WHERE 1 = 2"
Set cnns = OpenDatabase(vmdb)
cnns.Execute Sql
cnns.Close

Regards Trob70

 

[Schroeder]

Just keep in mind this method does not copy other attributes of your source table - no indexes (including Primary Key) or foreign key constraints (if you're into that kinda thing), etc.