import/update from xls

[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.

 

[Guest]

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.

 

[Andrew L.]

If I do want to import only new or changed records, rather than
linking, how do I do that?

Andrew