Dim cnn As New ADODB.Connection Dim sqlString As String cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & App.Path & "\Data\Feedb.mdb;" & "Jet OLEDB:Engine Type=4" sqlString = "INSERT INTO ZHK SELECT * FROM [dBase III;DATABASE=" & pMndDatePath & "].[" & .Fields!xdm & .Fields!cdm & "]" cnn.Execute sqlStringor'adoConnection.Execute "SELECT * INTO CopyOfAnimals FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]" 'adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"
再到连接 access 中执行就可以了。当然,还有别的方便的方法,就是对像去对像之间的写法,很简单。
Dim sqlString As String
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & App.Path & "\Data\Feedb.mdb;" & "Jet OLEDB:Engine Type=4"
sqlString = "INSERT INTO ZHK SELECT * FROM [dBase III;DATABASE=" & pMndDatePath & "].[" & .Fields!xdm & .Fields!cdm & "]"
cnn.Execute sqlStringor'adoConnection.Execute "SELECT * INTO CopyOfAnimals FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"
'adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"