File Export to CSV

  • Thread starter Thread starter celine
  • Start date Start date
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?
 
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.
 
Back
Top