A simple MDB question...

  • Thread starter Thread starter Anon
  • Start date Start date
A

Anon

Hello All!
I am trying to merge two tables from two different MDB's into one. I know I
can just append the records from the second table into the first or vice
versa, which will suffice in my situation, however, I'm not sure what the
the correct way to do it.
here i smy thinking on it, generate a rs from the second table, close the
ADO connection and open another ado connection to the second MDB, and append
this record set, however, do I have to set the RS's active connection to the
new connection?

TIA
Luis
 
You should put your question into the ADO newsgroup rather than the VB.NET

Thanx - OHM
 
Back
Top