Hi,
I have been working on vb.net project and I am creating a table.
the syntax is like this:

sql = "CREATE TABLE " & s & "(id number(5),val text (9) )"

here i am trying to connect to an access databse and i am storing the name of the table in variable s.
But i get an error which is either field definition error or create table syntax error.Plz help

example (replace source, table name etc):

Dim adoCon As New ADODB.Connection
Dim rsPerson As New ADODB.Recordset
Dim strCon As String

strTableName = "aaaaa"
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb"
adoCon.Open strCon
strSQL = "Create table " & tableName & " (id number(5),val text (9))"
adoCon.Execute(strSQL)


If that doesn't work, try changing the names of the fields to lngID and strVal.