File Export to CSV

C

celine

When exporting file to csv the Null values are not shown with the delimiter.
Anyone know how to Export Null Fields to Delimited-Text Format Files?
 
A

Allen Browne

celine said:
When exporting file to csv the Null values are not shown with the
delimiter.
Anyone know how to Export Null Fields to Delimited-Text Format Files?
Click to expand...

Perhaps you could try using Nz() to get a zero-length string, by typing an
expression like this into the Field row in query design:
Nz([YourTextFieldNameHere], "")
and then exporting the query.

Untested. See how you go.
 
Top