Export null to .csv

Question

I'm using the export data wizard in sql server 2005.

I've got a table with null values in many of the fields. I'd like to keep these fields as I export to .csv but they are being replaced with empty strings.

I've tried changing the 'nullable' checkbox for the fields in the wizard, but that doesn't seem to do anything. Also tried using " as a delimiter, since without delimiters, NULL would be interpreted as a string.

Answer 1

There's no such thing as a null in .csv files. Like you said, a value of null, "null" or "" would all be interpreted as a string value. Consider changing your source so it adds a "ColumnXIsNull" value to the exported records.