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 sqlString
or
'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\]"