Set rs = cn.Execute("select 字段名 from 表3 order by id")
Do While Not rs.EOF
strField = strField & "," & rs("字段名").Value
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
If strField = "" Then
MsgBox "表3只设有定义字段!", vbExclamation, "提示"
Else
strField = Mid(strField, 2)
cn.Execute "Insert Into 表1 (" & strField & ") select " & strField & " from 表2"
End If