DAO Preformance Problem

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I'm dealing with updating data from other sources

For this i import the new data to table on my access database and maching it
with my current data on my database

This is what should happen:
1. New row on the the import table it should be added straight to my
database
2. row exist on my database (according to key on both tables) some of the
data should be updated and other shouldn't. according the fields that being
updated and bring a message on a table
3. there is row on the database that don't exist on the imported table. Give
a message on a table

This comlex issue i can't do it using sql. So it seems (as far as i know)
that it should be done in vb.

The problem is that the amount data i add is quite huge (approx 5000, 10000)
rows and on vb it takes two long.

How can i short the process ?

any help would be useful
 
Roy,

I expect that you should be able to do what you want using a couple of
Update Queries and an Append Query. I imagine this would be a very
quick process. For step 1, you can make a query including your existing
table and your imported table, with a left join on the key field, which
will allow you to identify records in the imported table that do not
already exist in the existing data, and then make this into an Append
Query to add these records to the existing table. However, I would do
step 1 after steps 2 and 3. Step 2 will be a simple Update Quey based
on a query that joins the two tables. I am not sure what you mean
"bring a message on a table".
 
Back
Top