How do I update Access table fields from Excel file

[Daryl Austin]

I know this can be down, I'm just not sure where to begin.

I have a table with fields [quote#, salesagent, year, close,status], basically I am using Access to manage sales proposals. I export out to Excel a report query based on salesagent. I send this to each salesagent for updating.

Now I have the returned Excel file from the different salesagents. How do I import or update my original table fields with the new information from the Excel files?

Thanks.

[TheSmileyCoder]

There are quite a few ways it can be done, ranging from a simple export to coding a open and read from the excel. It depends on the layout of the excel sheet. Could you provide an example (screenshot for instance) of your excel sheet?

[Daryl Austin]

SmileyCoder,
I just posted the screen capture. Basically, I'm trying to find a relatively easy way to import and update the table fields with new data from the saleperson. I've been reading about Append Queries but I really need to just start with the basics first. Your help is appreciated.

[TheSmileyCoder]

If the "area" you want to export from within the excel sheet is a named range, I believe you can import just that using:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "[TableToImportTo]", "Path to File",,"NameOfRange" 

Now this just puts the records into a table. From here you would have to run an update query to update the original records.