1) Import the data into a new flat table (ie: without indexes).
2) Run a report on the key field (identityf) -- there must be no duplicates.
select indentityf, count(*)
from newtable
group by identityf
having count(*)>1
should yield no results.
3) Correct the spreadsheet.
4) reimport the spreadsheet.
"Bill" <bi***********@gospellight.com> wrote in message
news:8d*************************@posting.google.co m...
I have a table for authors (for our bookstore) that has several fields
(firstname, lastname, etc.) and an author_id field (set as identity)
I'm trying to import a spreadsheet into this table, but keep getting
error messages that say I can't import data into the author_id field
(the identityf field).
Can someone suggest what I can do to overcome this?
Thanks,
Bill