I continue to get the the following error when importing a CVS file into SqlServer2000:
"cannot insert duplicate key row in object 'table1" with unique index 'table1_ndx'.
I have looked at the records and there are no duplicates. No matter how many rows I test, I continue to get this error after the last row. Is the problem an EOF indicator? Can anyone tell me what the EOF for a CVS is? I would really appreciate it. I have tried everything I know.
Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive?
Marge Simpson: That's because you were drunk!
Homer: And how.
"cannot insert duplicate key row in object 'table1" with unique index 'table1_ndx'.
I have looked at the records and there are no duplicates. No matter how many rows I test, I continue to get this error after the last row. Is the problem an EOF indicator? Can anyone tell me what the EOF for a CVS is? I would really appreciate it. I have tried everything I know.
Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive?
Marge Simpson: That's because you were drunk!
Homer: And how.