Help with multiple connector/table query

[Alan Morris]

As a newbie to ADO.NET I am struggling with the following:

I have an ODBC data table that I want to use a source for updates to a
SQL server table, I envisage the sql query having the following
structure:-

INSERT INTO SQL_TABLE FROM SELECT ODBC_TABLE WHERE ODBC_TABLE.KEY NOT
IN (SELECT SQL_TABLE.KEY FROM SQL_TABLE)

How do I do this in ado.net if a sql query is run against a specific
connection object?

Hope the above makes sense.

Help greatly appreciated.

Regards,

 

[Alan Morris]

Many thanks your reply, I am using ODBC because the source database is
proprietary (non SQL server).

Regards,