I am using the following statement to create a table using contents of a qyery 'Control Plan'.
dbs.Execute "SELECT [Control PLan].* INTO " _
& "[tblTest] FROM [Control Plan]
All I need is to be able to indicate a primary key. I tried using the following statement but it does not work as there is error message 'Syntax in FRom Clause. Will appreciate if you could help.
dbs.Execute "SELECT [Control PLan].* INTO " _
& "[tblTest] FROM [Control Plan]CONSTRAINT [ProjectNo]PRIMARY KEY;"
Cheers
AK
dbs.Execute "SELECT [Control PLan].* INTO " _
& "[tblTest] FROM [Control Plan]
All I need is to be able to indicate a primary key. I tried using the following statement but it does not work as there is error message 'Syntax in FRom Clause. Will appreciate if you could help.
dbs.Execute "SELECT [Control PLan].* INTO " _
& "[tblTest] FROM [Control Plan]CONSTRAINT [ProjectNo]PRIMARY KEY;"
Cheers
AK