Import new field into existing indexed table

  • Thread starter Thread starter petersen.jesse
  • Start date Start date
P

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
 
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
Click to expand...

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.
 
Back
Top