Hi guys
Well I have two tables in two distinct dbs(of course the tables’ stracture are the same. I mean the same fields &…). And I want to move some records of one to another. The simplest and the slowest way to this is to:
1.read on record form A
2.add the record to B
3.remove the record from A
and do it for each record to the end. But it is toooooo slow. I’m looking for a way that I can create a recordset of records I want to move. And just add the recordset to the table but I don’t know how to do this. I mean adding a recordset to a table.
Can anybody help or give me some other solution to this?
thanks alot