How to update a field using Excel as input

[sumdumgai]

I exported about 190,000 records (about half of all records in the table) from Access DB to Excel. I then updated two fields (that were previously blank on the database) on the Excel sheet with values. What is the easiest way to import these new values back into the database table so that the records receive their respective values? Thanks.

 

[Old Man Devin]

I believe you can make the spreadsheet a linked table (via the external data tab), then use an Update query from that table to your old one to get the new values in (with 'is null' as the update condition if all the old ones were blank).

If you want more info on how to do these things feel free to ask!