Importing excel file to append a table

[vickan240sx]

Hi,



Is the record is already existing in access, but a few fields are blank, is there any way to import an excel file that just updates those blank fields for the specific record?

For example,

I have an excel file that includes files that are ready to ship out. My access database already has those file names, but does not have the shipping box number. Is there any way to import the excel file into my database, have it find those specific file names and update the shipping box number field? The excel file won't be adding any new records, just appending existing records.

Any help is greatly appreciated.

Thank you.

[John_G]

As long as you have a unique field common to both the Access table and spreadsheet (filename?), you can do this.

First, create a link to the Excel spreadsheet (this is File - Get External Data - Link Tables in Access 2003; I'm not sure what it is in A2007). Once you have done that, you can use the Excel spreadsheet in a query as you would a regular table.

Create an Update query joining the Access Table and the Excel spreadsheet, then update the MS Access fields from the corresponding columns in the spreadsheet. That should do it for you.

John