可以用DAO呀! Dim db As Database Dim td As TableDef '表 Dim fld As Field ‘单元 Set db = DBEngine(0).CreateDatabase(FileNames, dbLangChineseTraditional) Set td = db.CreateTableDef("TableName") Set fld = td.CreateField("FieldName", FieldType) td.Fields.Append fld db.TableDefs.Append td set fld=Nothing set td=Nothing set db=Nothing
用ADO:dim cn as new adodb.connection cn.open "provider=..."cn.execute "create ........"
Dim db As Database
Dim td As TableDef '表
Dim fld As Field ‘单元
Set db = DBEngine(0).CreateDatabase(FileNames, dbLangChineseTraditional)
Set td = db.CreateTableDef("TableName")
Set fld = td.CreateField("FieldName", FieldType)
td.Fields.Append fld
db.TableDefs.Append td
set fld=Nothing
set td=Nothing
set db=Nothing
cn.open "provider=..."cn.execute "create ........"
最好是用ADO。
我的程序就是W2K+O2000呀!只是不能调EXCEL,不过加上EXCEL的类就可以了实现了
Set Wrk = DBEngine.Workspaces(0)
Set dbs = Wrk.CreateDatabase(App.Path & "\" & DatabaseName & TableName & "Outputtemp.mdb", dbLangChineseSimplified)
Set tdfNew = dbs.CreateTableDef(TableName) tdfNew.Fields.Append tdfNew.CreateField(Col1, dbText)
tdfNew.Fields.Append tdfNew.CreateField(Col2, dbText)
tdfNew.Fields.Append tdfNew.CreateField(Col3, dbText)
tdfNew.Fields.Append tdfNew.CreateField(Col4, dbText)
dbs.TableDefs.Append tdfNew