Linn
Tue Jan 31 13:48:58 CST 2006
Yeah, you got it Carsten. I had a candidate-key on another field that I
wasn't importing. It had no default so every record was blank which
obviously wouldn't work. It just threw me since it referenced the primary
key in the error message.
Thanks again to you and Cindy for the help.
Linn
"Carsten Bonde" <bonde AT real-inkasso DOT de> wrote in message
news:e7CMYmlJGHA.516@TK2MSFTNGP15.phx.gbl...
> Linn,
>
> do you have a candidate-key in your table? Notice that deleted records
> also count as keys.
>
> Try opening your table, and pack it:
>
> USE <table> EXCL
> PACK
>
> and see if it helps.
>
> --
> Cheers
> Carsten
> _______________________________
>
> "Linn Kubler" <lkubler@chartwellwisc2.com> schrieb im Newsbeitrag
> news:uEVpAJfJGHA.532@TK2MSFTNGP15.phx.gbl...
>> Hi Cindy, thanks for responding so quickly. No, all the numbers in my
>> data are integers under 1000. I removed the first line in the text field
>> that had the field names anticipating that problem. I forgot to mention
>> that the first record does import correctly so I get that far.
>>
>> I tried removing the primary index but I still get the error, that's odd.
>>
>> Thanks,
>> Linn
>>
>> "Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
>> news:uS5o7yeJGHA.1188@TK2MSFTNGP14.phx.gbl...
>>> Hi Linn,
>>>
>>> For what it's worth, I've encountered problems saving Excel data to text
>>> files when there are comma separators in the numbers, so watch out for
>>> that if you haven't already dealt with it.
>>>
>>> Is there a row at the top of your text file that contains the field
>>> names?
>>>
>>> Perhaps the simplest thing is to remove the Primary index from the first
>>> field, import the data, and then check for duplicates. Then re-apply the
>>> Primary index.
>>>
>>> --
>>> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
>>> cindy_winegarden@msn.com www.cindywinegarden.com
>>>
>>>
>>> "Linn Kubler" <lkubler@chartwellwisc2.com> wrote in message
>>> news:uJlHxqeJGHA.1032@TK2MSFTNGP10.phx.gbl...
>>>> Hi,
>>>>
>>>> I am creating a new database and I have records in Excel that I want to
>>>> import into my new table. I originally tried importing straight from
>>>> the Excel workbook but had troubles so I saved the data in a tab
>>>> delimited text file. The first field in the text file is the primary
>>>> key field in my table but when I perform the import I get an error,
>>>> "Uniqueness of index PROP_NO is violated". I've double checked my data
>>>> and there are no violations that I can see, how can I determine where
>>>> my error is? Or what am I doing wrong?
>>>>
>>>> Thanks in advance,
>>>> Linn
>>>>
>>>>
>>>
>>>
>>
>>
>
>