Updating Records

[Guest]

in I have a table of merchant data. One of the fields is named Status. As
each record is worked, the users fill in the status on a form. I have just
received a spreadsheet to update the status of some, but not all records.
There has to be a way to do this is Access...can someone help??? Thanks!

 

[John Vinson]

in I have a table of merchant data. One of the fields is named Status. As
each record is worked, the users fill in the status on a form. I have just
received a spreadsheet to update the status of some, but not all records.
There has to be a way to do this is Access...can someone help??? Thanks!

Certainly; an Update query is designed to do exactly this.

Use File... Get External Data to either Link to or Import the
spreadsheet.

Create a Query joining your merchant data table to the linked/imported
data by some field which uniquely identifies which row needs to be
updated.

Change the query to an Update query, and on the Update To line under
Status put

[<name of your new table>].[Status]

Run the query by clicking the ! icon.


John W. Vinson[MVP]

 

[V? Ð?nh Tu?n]

thankoy