Update and Compare table records (1 Viewer)

Hi
I'm using MS Office 2000, I have an Access database table that contain many fields, namely I need to update FieldA from an Excel Spreadsheet according to the specified primary key of CustomerID. Is there a way to write automate process to import the records from an excel spreadsheet and then place those records in FieldA of the Access Database according to the corresponding CustomerID? The reason I ask is that these two fields are not exactly in the right order in my spreadsheet and my table and to do it manually will take lots of effort.

Your prompt response is greatly appreciated

Thanks

use TransferSpreadsheet to import or link the the Excel table. then run your Update query.

Thanks. What would my Update query be like? Any samples?

I don't have a clue since I don't know your data. You should manually link/import the spreadsheet once then use Query Designer to build your Update query. Store it and use DoCmd.OpenQuery to run it adter the TransferSpreadsheet