Update/insert one table from another

  • Thread starter Thread starter Eashrak
  • Start date Start date
E

Eashrak

Hi

I need to perform following querie in vb.net

The queries are;

NSERT INTO [destTbl] (field1, field2)
SELECT srcTbl.field1, srcTbl.field2
FROM srcTbl
WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl])));


In access I just run these query and job is done without any need for
datadatpters etc. What is the easiest way to execute these two queries in
ado.net/vb.net?


Thanks
 
Back
Top