Multiple Database Query

[dee-u]

To populate a table from another table in another Access database then you can try something like this.

Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=c:\db1.mdb;Persist Security Info=False;"
cnn.Open
cnn.Execute "INSERT INTO Tablex IN 'c:\db2.mdb' SELECT FROM Tablex;"
cnn.Close
Set cnn = Nothing