I need to create an ms access table in an .mdb file. i've been using this code to do so :
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
VB.NET:
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