Update current records with an excel file

[aaronmib]

I have an excel file with updated information for 2 columns in my database. The values are different for each record and I was wondering if there is a quick way to update the files.

Thanks

 

[Alansidman]

Import the excel fiel into Access into a temp table. Run an update query to take the information from the temp table and update the permanent table.

Alan

 

[John Big Booty]

Check the sample posted in this thread for an example.