Hi Laura,

I've opened a bug on this:

https://www.labkey.org/issues/home/Developer/issues/details.view?issueId=23996

Sorry for my confusion about NA vs NULL. You current workaround seems reasonable. As an alternative, I think this would work:

Split the data frame into two separate date frames. One will have all of the rows with non-NA values for the column in question, and the other will have all of the rows with NAs for that column. Delete the column in the data frame where all the values are NA. The insert them separately with two different calls to insertRows().

This should end up with all of the rows, and null values in the database for the rows that have NA, which is the desired end result.

Thanks,
Josh