Probably a dumb question

[grassaj]

I have to databases, db1 and db2. I am using db1 to create a connection and recordset to db2. So, all the data I want is in a recordset. How do I insert that data into a table that I have created in db1?

 

[Alexandre]

Did you consider using SQL? No doubt it is feasable with recordsets, but it is generally a heavier and slower approach.

Alex

 

[grassaj]

I'm using already using SQL to extract the data to the recordset, but once it's there, I want to put it into a template table that I've already created- the problem is that my connection to the recordset is to db2, and I want to put the data in a table in db1.

 

[David R]

What about linked tables?