Multiple Database Query

[ravininave]

Hi,
I've to fetch data from Multiple database from the same server to new table. I'm using MS Access and VB 6. Actually we've 4 packages running on same server with different locations and we have to show all the employees from all database (all have same table structure). Can anyone Help.?

[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

[leinad31]

You might want to consider consolidating access databases to a single database for a long term solution... application rewrite will be expensive later on when you need to consolidate data and time could have been spent on other tasks (investment wasted) .