Import Questions

[missymarie1014]

This is Access 2000. Is it possible to import data into an existing table for the purpose of updating existing fields with revised information? For example, edits to item descriptions, quantity on hands from a year end inventory count. Rather than changing the items manually, I want to import the data, preserve the existing data and only have the data in some specific fields be modified. What is the best approach to this? Thanks for any assistance!

 

[MajP]

I would assume an update query. But what format/source is the new data?

 

[missymarie1014]

The new data is sitting in an Excel spreadsheet

 

[MajP]

You should be able to link to your excel spreadsheet as an external table and then do a simple update query. You would have to provide more specifics on your table desingns to get a more detailed answer
here is a simple example where I have a personnel table and a linked spread sheet. I am updating everyones date of birth from the spreadsheet

UPDATE tblPersonnel INNER JOIN ssPersonnel ON tblPersonnel.autoPersonnelID = ssPersonnel.autoPersonnelID SET tblPersonnel.dateDOB = [ssPersonnel].[dateDOB];