我现已得到数据库中的表名(cOneTable) ,可是不知道如何写一条语句完全复制该表
到新数据库中?请各位大侠看一下:
Private Sub ToNewAccess(cOneTable As String)
Dim MdbFile As String, TableName As String, FieldName As String, FieldType As DAO.DataTypeEnum, FieldSize As Long
Dim cat As ADOX.Catalog
Dim adocon As ADODB.Connection
Dim cSql As String
Set adocon = New ADODB.Connection
adocon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;" & _
"Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;" & _
"Jet OLEDB:Database Password=19819800" '
Set cat = New ADOX.Catalog
Set cat.ActiveConnection = adocon
MdbFile = App.Path & "\NewData.mdb" '新数据库名称
cSql = "Select * INTO " & TableName & " [IN " & MdbFile & "] From " & TableName
adocon.Execute cSql《-提示:查询输入必须包含至少一个表或查询?我不会写查询语句,请高手
指点错在哪里呀,谢谢。
Set cat = Nothing
adocon.Close
Set adocon = Nothing
End Sub