Access 2000: Update or Append Query?

[mluedey]

I have a table with 3 fields that I want to import data from and into
an Oracle table.

I have the odbc set up and have the 'link table' in my db as well as
the source table (access). Do I use an UPDATE query to move that data
to Oracle or an Append query?


thanks much!

 

[Guest]

Append to add new records. Update only changes the info in existing records.
So if this is brand new info for the database (a new record) then Append.
But if there is a chance the data is there already and you need to find it
and replace it with your newer data you need to do the Update. I often do
both: an update first and then an append.

But NEVER do an update unless you know you want to change existing records -
you are overwriting existing data.

 

[Pharoh]

Thanks much!

I'm not sure why I was confused, I've done this before. I think what
happened was that I didn't create a join to the matching tables and
when I ran the query against my test instance it appended 0 rows
instead of 1. Once I created the join it worked fine.

thanks again!