Inserting rows from one table into another?
Hi
I want to insert some rows form dbSource.table1 into dbTarget.table1, in ADO.Net how should I do this?
In DAO I used to do it with such code:
dbTarget.Execute "Insert Into table2 Select * From table1 IN '" _
+ dbSource.Name + "' Where someField = ‘Something’"
BTW the 2 db’s are located on another computer in the LAN (on the server). I want to perform this operation on the server without having to take any records to the client’s computer.
Can anyone help me please, or can you tell me if it’s possible?
Thanks