建表 Private Sub Command1_Click() Dim cn As New ADODB.Connection cn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp.mdb;Persist Security Info=False" cn.Open cn.Execute "CREATE TABLE [bbb]([字段1]Text(20),[字段2]Integer,[字段3]Double,...)" cn.Close End Sub '删表 Private Sub Command2_Click() Dim cn As New ADODB.Connection cn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp.mdb;Persist Security Info=False" cn.Open cn.Execute "DROP TABLE [bbb]" cn.Close End Sub
CREAT TABBLE TABLENAME 创建一个表
ALTER TABLE TABLENAME ADDCOLUMN COLUMNNAME TYPE 添加一列
具体的参见SQL的语法.
<column_1, sysname, c1> <datatype_for_column_1, , int> NULL,
<column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL)
如conn.Excute 创建表的SQL语句另外可以使用ADOX(ADO扩展)来创建表
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
cn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp.mdb;Persist Security Info=False"
cn.Open
cn.Execute "CREATE TABLE [bbb]([字段1]Text(20),[字段2]Integer,[字段3]Double,...)"
cn.Close
End Sub
'删表
Private Sub Command2_Click()
Dim cn As New ADODB.Connection
cn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp.mdb;Persist Security Info=False"
cn.Open
cn.Execute "DROP TABLE [bbb]"
cn.Close
End Sub