Unanswered: Update Fields in DB from Excel Cell values automatically?
Wondering how I can update an Access 2007 database with an excel 2007spreadsheet?
Have a database with addresses and then a bunch of fields(prices) that go with each address.
We get new price changes in an excel format and the list can be kinda big.
Be nice to somehow update the PRICE in the database automatically BUT it has to update the right record with right price of course. the excel sheet may not be in the same order as the records are in the accesss DB.
I did create an access table and link it to an excel sheet and it did function BUT for what we want to do...
that excel table is going to change with NEW records and current records being removed and order may change..
AND we only want to update one field from the excel table to the access database and basically it Has to look at the address to make sure it updates the correct record.
i'm almost thinking this is going to take some coding to get it right..don't know