>Hi Folks, Thaks for all your help.
>
>What worked was:
>>>>>>SET IDENTITY_INSERT MYTABLE ON (***** NOT OFF *****)
>>>>>>IMport the VFP data
>>>>>>SET IDENTITY_INSERT MYTABLE OFF (***** NOT ON ***)
>
>Sql seems to look at the highest Key and assign the next highets number
>Still dont know what hapens if I have Gaps and I reached the highest number... does it use the gaps or error out
>Regards,
>Gerard
>
>
Nope, the gaps are not used and it continue from the next number.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.