How to Export Null Fields to Delimited-Text Format Files in Access

Z

ZAPPER

In doing an export, I need to have null fields show quotes. Example...
,"data", "test","","","moredate" Can anyone help with this?
 
D

Douglas J. Steele

Create a query, and rather than showing the field, use a calculated value of

Nz(MyField, """"""")

(That's 6 double quotes in a row.)

Export the query, not the table.
 
Top