我用ACCESS建立了一个数据库DB1,然后我想用VB语句在DB1中建一个表
请问这样该怎么做
请问这样该怎么做
解决方案 »
- vb读取用word转换成的xml里的数据
- 请人做程序,把文件夹做成 目录,
- FindWindow的使用
- 高手求教用PaintPicture方法从左到右显示图像的方法
- 关于窗体的问题,各位高手可以进来看看,有道理都给分
- VB自带的打包程序的问题,急!!!!
- 我想做一个交通灯那样的东西,想知道怎样动态改变里面灯的状态?
- 关于窗体置前.(如何才能让窗体置于一个全屏模式程序的前面)
- 有哪位大哥知道用VB6对IE历史操作
- 如何在listview中显示向上的箭头,就象windows commander一样,因为我想编一个文件管理程序?
- ···陨落雕已经在上海了···
- 关于RasGetEntryDialParams
On Error Resume Next
Dim mycat As New ADOX.Catalog
Dim mytable As New ADOX.Table
mycat.ActiveConnection = "Provider=MicroSoft.Jet.OLEDB.3.51;Data Source=e:\db1.MDB"
For i = 1 To 9
mytable.Name = "表" & i
mytable.Columns.Append "字段1", adDate
mytable.Columns.Append "字段2", adInteger
mytable.Columns.Append "字段3", adBoolean
mytable.Columns.Append "字段4", adVarChar
mycat.Tables.Append mytable
Set mytable = Nothing
Next
MsgBox "创建 表1----表9 成功!"
Set mycat.ActiveConnection = Nothing
End Sub
2.也可以调用Create表的SQL语句
引用 Microsoft ADO Ext. 2.7 for DDL and SecurityThe following code shows how to create a new Microsoft Jet database with the Create method.Attribute VB_Name = "Create"
Option Explicit' BeginCreateDatabseVB
Sub CreateDatabase() Dim cat As New ADOX.Catalog
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\new.mdb"End Sub
' EndCreateDatabaseVBThe following code demonstrates how to create a new table.' BeginCreateTableVB
Sub CreateTable() Dim tbl As New Table
Dim cat As New ADOX.Catalog'Open the catalog.
' Open the Catalog.
cat.ActiveConnection = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\Program Files\Microsoft Office\" & _
"Office\Samples\Northwind.mdb;" tbl.Name = "MyTable"
tbl.Columns.Append "Column1", adInteger
tbl.Columns.Append "Column2", adInteger
tbl.Columns.Append "Column3", adVarWChar, 50
cat.Tables.Append tblEnd Sub
Dim MyDatabase As Database
Set MyDatabase = CreateDatabase("c:\Trade.mdb", dbLangGeneral, dbEncrypt)
Set MyTable = MyDatabase.CreateTableDef("System")
Set MyField = MyTable.CreateField("APPLNAME", dbText, 100) '项目名称
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("SERVERNAME", dbText, 15) '服务器名称
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("LOGONNAME", dbText, 15) '数据库用户
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("PASSWORD", dbText, 15) '数据库口令
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("DATANAME", dbText, 15) '数据库名称
MyTable.Fields.Append MyField
MyDatabase.TableDefs.Append MyTable MyDatabase.Close