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

  • Thread starter Thread starter ZAPPER
  • Start date Start date
Z

ZAPPER

In doing an export, I need to have null fields show quotes. Example...
,"data", "test","","","moredate" Can anyone help with this?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed Width - No delimiters - ASCII Text File 7
Export to Tab delimited text file 4
Delimited Export Specification - independent of table 3
How to export so that null fields have quotes as qualifiers. 1
Export Date without Time to text tab delimited file 3
how to change default values (delimiter etc) for Export Wizard 6
Exporting Table to Text file including Fielnames 2
Generic Export Format 1

Back
Top