Updating/appending information

  • Thread starter Thread starter ncaskey
  • Start date Start date
N

ncaskey

Is there a way to do a "compare" between the information in my Access 2007
table and an Excel file?

I'm trying to update one field in a table in Access with the most recent
information from Excel which I would like to use an External Data import.

For example, my Excel field would have one field that is the "match" in
Access. There is another common field in both Access and the Excel file. I
want a query (?) to run that would compare the first field and if it matches,
update the second field in my Access database.

It sounds logical to me but I'm at a loss.

Thanks!
 
Set up a link to the Excel file in Access and then so a query which sets the
relationship on your key field. The default is to only show records where the
key field matches which I think is what you want.

Change to an update query and set the Update To row to
[Spreadsheet_Name]![FieldName] I think this will work but please make a
backup of your table first!!

Sheila
 
Back
Top