Sarah Sweeney wrote: > Is there some option I can add to the create table definition that will > make this work, or a database-wide setting that will work? Any > suggestions on how to fix this problem will be greatly appreciated. > ususally when a default option is needed, i try to use -1 as the value. it tends to go over smoother and avoid the problems you are hitting right now. make a back up of your data, if any. truncate the table, which will remove all PK's with it. REMOVE the definition of the PK on the id row. insert the -1 row manually put the primary key back on the table. load data. that should work. if it doesn't, sorry for wasting yoru time. maybe someone else can elaborate on the -1 usage some.