Hi there, I am trying to import the data to sql server. I want to set the "Marker ID" and "Pheno ID" NULLABLE=FALSE, but "P value" NULLABLE=TRUE How should I add it to the sqlsave function? sqlSave(ch,newdata,tablename=newdata_name, varTypes=list("Marker ID"="int", "Pheno ID"="smallint", "P value"="float"), rownames = F, addPK = F) Thanks, Qian [[alternative HTML version deleted]]