How can i add a field to a access db table. using ado and jet
Printable View
How can i add a field to a access db table. using ado and jet
You can execute an Alter Table statement. Following is the syntax supported by Jet/Access
ALTER TABLE table {ADD {COLUMN field type[(size)] [NOT NULL] [CONSTRAINT index] |
CONSTRAINT multifieldindex} |
DROP {COLUMN field I CONSTRAINT indexname} }
strSQL = "Alter Table Shippers Add Column Testing Text(10) Null Default 'Hello'"
No special mode just open the connection and execute an SQL statement on a command object.