updating fiields that match other fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with 12 fiields. I dynamically pull this data into my .asp
website.

Two of these fields are important. The MODEL field and the PRICE feilds.

The price fields contains 2006 pricing. Once a year at year end, data entry
manually enters pricing into our proprietary system. I then can download a
..csv file and bring into excel. I now have a file with all our MODELS and the
NEW 2007 pricing.

How can I import the NEW 2007 prices into my existing database to only
replace the 2006 pricing without messing up the fileds. each model much have
a new 2007 price. Can these models do some kind of match, and if the price IS
different, it changes it?
 
Link the .csv file as a table.
Create an Update Query that joins your Access table and the Linked table on
MODEL and updates the Access table. Update the PRICE field with the value in
the Linked table PRICE field.

So once the query is created, the sequence of events is:

Link the .csv file
Run the Query
Delete the Link
 
Back
Top