Add a column

[Never4Get]

Now that I found a way to import a .dbf-file, I would like to insert a column in the resulting table. Could someone tell me how please???

Thanx in advance

 

[disgruntled]

this will add a column to the table.

Dim tableSQL As String
tableSQL = "Alter TABLE [" & tableName & "] ADD COLUMN COLUMN_NAME Integer;"
db.Execute (tableSQL)

 

[fmm]

Go to the Design view for the table and add a field.

 

[Never4Get]

Thanks digruntled,

Your SQL-statement worked fine.