Key Violation Error

C

Chezter

Hi All,

I have an Access table called tblUnits that holds information about each
subject offered by my organisation. In excel, I have a table with the field
'Prerequisite', which has a corresponding field in the access table. The
Prerequisites field holds extra information about some of the records in the
tblUnit. I want to match up the information from the excel spreadsheet with
the records in the access table.

I have tried importing via the Get External data command, but of course it
gives me a key vioaltion error, as it thinks I am trying to duplicate the
records.

Not sure if I need an append query or update query and if so how to write it;
or if there is some better method. Any advice would be greatly appreciated.

thanks in anticipation,
Heather
 
G

Golfinray

Try linking the Access table to the Excel spreasheet. Then anytime the
spreadsheet is updated, the table will automatically get updated also. Go to
File/get external data/link tables.
 
Top