7,713
社区成员
发帖
与我相关
我的任务
分享
'根据tableA动态生成表tableB
Public Sub CreateTable()
Dim strCreateTable As String
Dim strSQL As String
Dim Cnn As New ADODB.Connection
Dim Rst As New ADODB.Recordset
Set Cnn = CurrentProject.Connection
strCreateTable = "Create table tableB (id int "
strSQL = "select [Name] from tableA order by [id]"
Rst.Open strSQL, Cnn, adOpenKeyset, adLockReadOnly
If Not Rst.EOF Then
Rst.MoveFirst
Do While Not Rst.EOF
strCreateTable = strCreateTable & ", [" & Rst!Name & "] text(100) "
Rst.MoveNext
Loop
End If
strCreateTable = strCreateTable & ")"
Debug.Print strCreateTable
Cnn.Execute strCreateTable
MsgBox "OK"
End Sub