Dim cn As New ADODB.Connection Dim strSQL As StringstrSQL = "create table table1(id numeric(10,0) not null, name char(16), age integer, sex bit,primary key(id))" cn.Execute strSQL
引用ado dim conn as new connection Dim Compublishers As New ADODB.CommandSet Conn = New Connection With Conn .Provider = "sqloledb" .ConnectionString = "User ID=sa;Password=" & Trim(Strpassword) & ";data source=" & Trim(Strservername) & ";initial catalog=OLTest" .Open End With With Compublishers .ActiveConnection = Conn .CommandText = "create table temp (mc char(20),km char(20),sj datetime,jgl float(8),bmrs float(8),ksrs float(8),zgf float(8),zdf float(8))" .Execute End With
Dim strSQL As StringstrSQL = "create table table1(id numeric(10,0) not null, name char(16), age integer, sex bit,primary key(id))"
cn.Execute strSQL
我就不贴了
dim conn as new connection
Dim Compublishers As New ADODB.CommandSet Conn = New Connection
With Conn
.Provider = "sqloledb"
.ConnectionString = "User ID=sa;Password=" & Trim(Strpassword) & ";data source=" & Trim(Strservername) & ";initial catalog=OLTest"
.Open
End With
With Compublishers
.ActiveConnection = Conn
.CommandText = "create table temp (mc char(20),km char(20),sj datetime,jgl float(8),bmrs float(8),ksrs float(8),zgf float(8),zdf float(8))"
.Execute
End With