Tricky process question

  • Thread starter Thread starter Loren S. Teillon
  • Start date Start date
L

Loren S. Teillon

I'm trying to read records from a main table, along with data records
from dependant tables into a SQLAdapter. I will then need to make
some changes to certain field data. I will then need to insert these
records into another database (with same structures). Can some one
sling me some example code as how they would do this? The rudimentary
way would be to loop through each record, inserting into the
destination DB and then inserting dependant records as well.

But what would be snazzy would be to get all the data into a
SQLAdapter, with structure in place, disconnect from the original DB,
make mods as nessecary, then connect up to the destination DB and do a
one-method insert/update to the destination. Can this be done?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

transeferring data between databases 1
Access Automatically Send a notification email once a record is added 0
Record insert/delete anomaly 0
VBA - retrieve data on last create named range from previous inserted named range 0
DataSet transfer data from one database to another 14
Access Passing the value to a table 1
Copying a Record from one DataTable to Another. 4
Inserting Multi Table Dataset into Dataset 1

Back
Top