S
SirPoonga
What is the code to create a table using SQL in Access?
In VBA I want to make a table and define field properties.
In VBA I want to make a table and define field properties.
M
[MVP] S.Clark
You can use DDL - Data Definition Language or the Create method for Tabledef
object.
See the help file example in the Tabledef object help page thingy.
mk
MSITStore:C:\Program%20Files\Common%20Files\Microsoft%20Shared\OFFICE11\1033\dao360.chm::/damthcreatetabledefx.htm
object.
See the help file example in the Tabledef object help page thingy.
mk
MSITStore:C:\Program%20Files\Common%20Files\Microsoft%20Shared\OFFICE11\1033\dao360.chm::/damthcreatetabledefx.htm
A
Andi Mayer..
CREATE TABLE MyTable (myField1 Text)
more in the help (Microsoft Jet SQL Reference)