Merge Recordset

[spangeman]

Hello there.

I'm working on a VB 6 application and I need to combine data from different ODBC data sources e.g. their could be one from a SQL DB and one from an excel spreadsheet.

I can get all the data into ADO fine but is it then possible to merge the data based on some kind of join and create a merged recordset?

I have seen something similar in ADO dot Net but can't see anything like it in ADO. Unfortunatly I'm stuck with VB6 at the mo.

Regards
Spangeman

 

[JoeAtWork]

I think you would have to create a new recordset, create and append fields to it of the appropriate data types, then copy the data from the recordsets you opened from the various databases into this dynamically created recordset.