Using a spreadsheet structure to update database

I have an excel spreadsheet with 2 columns: id and price. I want to use the spreadsheet to update the prices in a database on a regular basis. I assume that I can do it by looping through the thing somehow and then updating the price as appropriate. I know that the sql is pretty simple - just

Re: Using a spreadsheet structure to update database

$ /CFQUERY Doug Brown - Original Message - From: Paul Sinclair [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 15, 2002 12:09 PM Subject: Using a spreadsheet structure to update database I have an excel spreadsheet with 2 columns: id and price. I want to use