Import new field into existing indexed table

[petersen.jesse]

We have an entirely new field of data to place into an existing table
from Excel with a primary key.

The Excel file contains the primary key from the existing table before
the new data was entered.

Is there a way to import an entire set of data to a field in an
indexed table? I only get key violations.

Thanks

 

[John W. Vinson]

We have an entirely new field of data to place into an existing table
from Excel with a primary key.

The Excel file contains the primary key from the existing table before
the new data was entered.

Is there a way to import an entire set of data to a field in an
indexed table? I only get key violations.

Thanks

You can't "import a field" into an existing table. You'll need to open the
table in design view; add the new field; and then run an Update query linking
(by the primary key) to the Excel table. Perhaps you could post the SQL of the
query, or the steps you're taking to import, and the actual error message
you're getting.