David C. Holley wrote:
Yes, if the values in the spreadsheet can be matched to products in the
database for example by using a Product Number. Its a simple matter to loop
through the rows in the spreadsheet and update the values in the database.

For the future though, whoever created the spreadsheet should be using the
database as it will eliminate the need to update the values. If the
spreadsheet was created by pulling data out of another system, your database
should pull the values from there.

David

What? WHy not attach the spreadsheet, inner join the two tables, and turn
that into an update query...

--
Message posted via http://www.accessmonster.com