Create ms access table

[TechFred]

I need to create an ms access table in an .mdb file. i've been using this code to do so :

Public con As ADODB.Connection
con.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data source ='c:\test.mdb';")        

con.Execute("CREATE TABLE Test1 (CustomerID AUTOINCREMENT, Name Char(20), Address Char(30), City Char(30), State Char(2), PostalCode Char(9))")
        
con.Close()

The problem is, it lacks of information about it on the web. I mean where i can find the list of the data type i can use? Example : AUTOINCREMENT, Char ......

Or if there is an another way, more efficient to make tables.

Thank you

 

[Stonkie]

You might have better luck looking for Jet SQL... Try this link : http://en.wikibooks.org/wiki/JET_Database

 

[TechFred]

Thank you for the link