import/update from xls

  • Thread starter Thread starter Andrew L.
  • Start date Start date
A

Andrew L.

I have created a table with data imported from an xls spreadsheet. I
allowed access to create an IdKey. Now I would like to update the
records in the table as the data in the xls has changed. Problem is
that when I did this, access created new records for every entry, even
those which already existed (perhaps because I created the key, it
didn't know those entries were duplicates?).

What is the best way to handle this when the source of data starts in
an xls?

I am pretty new to this, so please keep it fairly simple, thank you.

Andrew L.
 
Hey Andrew, the creation of the key is not what created the duplicate
records. Importing records will do just that -- import what's in the
spreadsheet. The easiest way to do this is to only import the new records
instead of the entire spreadsheet.

Another option is to link a table to your spreadsheet. To do this:

Go to File --> Get External Data --> Link Tables

Change the Files of Type to Microsoft Excel and find your spreadsheet.
 
If I do want to import only new or changed records, rather than
linking, how do I do that?

Andrew
 
Back
Top