ADODB . How to so an Update from external db to Table?

[MichaelRed]

I need to update a table in Ms. Access 2K from an exxternal db. I can get the connections/recordsets for each of the data sets. How do I use these to do an Update of the Native (Ms. Access table)

So far, I have rsTableA (the external data source) and tblTableA (the 'native/internal) table. I have sql statements to either Append records to [tblTableA] or Update the records in [tblTableA].

I don't see how I can build a command which references BOTH connections. No matter which connection I use, it cannot 'see' the data set generated under the other command.

I "thought" that - having generated the rsTableA and the tblTableA recordsets, I should just be able to then generate a command of the update sql statement.

Oops. NO!

Can someone show me what to do next?


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[MichaelRed]

Please. Some Big name should be able to do this.

MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over