>>>Thanks. That did the trick. Please could I trouble you as to any thoughts on the second part of my proble: re: NewID() disabling while I'm doing the import?
>>
>>Can you use DBSETPROP() function to disable default before import and enable it thereafter?
>
>Thanks, Sergey - that seems like a good idea. It made me think as well - I can probably use Alter Table ... drop/set default too. I'm just wondering which might be better.
>On the other hand, I originally thought that I was getting this violation error because I had the default value, which turned out to be not the case, so now I'm wondering if my Insert Into statement wouldn't just override the NewID() function anyway, given that I'm stipulating the value of Zone #.
The dbsetprop("alias.field","field","DefaultValue","any value") will not work because DefaultValue is read-only for DbSetProp() function when applied to tables. It's read/write for views, however - which may help you, who knows.