Answered How to creat field in Table Ms Access

[Mangore]

this code to create table in ms access

Dim cmd As New OleDbCommand("create table mytable (a string, b number)", conn)

how to create field in mytable

 

[JuggaloBrotha]

Your post is a little confusing, are you wanting to create a new table using sql or add a new column to an existing table using sql?

If you want to add a new column to an existing table, check out the Alter Table statement: ALTER TABLE Statement (Microsoft Access SQL)
If you want to create a new table, check out the Create Table statement: CREATE TABLE Statement (Microsoft Access SQL)

 

[Mangore]

Thank you for help!!