Database update using VB

[bengalliboy]

I need an easy way to update a database where VB is used to insert record from an Acces table. The criteria is to compare the old data (I got an old table and a new table and data is inserted to new table) w the new data and if it is not there then do the insert and if it is there then modify it (Assuming something changed..)

I want to do this in one step either using SQL or VB whatever easy way it can be..
TIA

 

[maxpower1]

Are you using 2 databases? Your question is not clear.

If you are retrieving from a table in access database and then storing it into an oracle
database and you could do it using ado datacontrol (if needed to be done in single step). If you plan to use sql statement, then you may not be able to do it in one statement because the first statement needs to connect to access db to retrieve data (using a different db connection object) and the second needs to write to the oracle db (I assume this is your question since you are posting in oracle forum)..

good luck

 

[bengalliboy]

Thanks, Yes I am using ADO and the connection / insert works fine. Question comes how to update it while doing a refresh... The next time I get new data that is a change of the old one as well as new data itself. Now VB does not know what is there... I am trying to use an automated tecknique... Any Idead?