Once you have your initial recordset, create a new connection to the second database, from there call your SQL statements using the new connection Do the same thing for the third database. Here is an example with 2 databases:
Dim Connection1 as ADODB.Connection
Dim Connection2 as ADODB.Connection
Dim rs as ADODB.Recordset
Set Connection1 = new ADODB.Connection
Set Connection2 = new ADODB.Connection
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!