Dim CONN As New ADODB.Connection
Dim rs As New ADODB.Recordset
CONN.ConnectionString = "provider=sqloledb;data source=jhd001;database=dujun;uid=sa;pwd="
CONN.Open
'CONN.Execute "select * into biaoo from biao where 1=2" '复制已有的表结构
CONN.Execute "CREATE TABLE [biao3] (" _
& "[CUS_ID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ," _
& "[CUS_NM] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL" _
& ") ON [PRIMARY] " '新建表结构
IT618资讯网 提供服务端开发,前端开发,网页特效,热门开源系统研究,软件下载,站长建站,淘宝开店等学习资料.