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
 

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

Help with INSERT statement. 2
Queries on tables from different data sources 1
Queries on tables from different data sources 1
Make-table query with around 2 ml records taking too long 0
Insert a crosstab to temp table 4
Shift several columns in table 4
Run a vb net procedure when sql table insert is triggered 5
Help with multiple connector/table query 1

Back
Top