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.
 

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

How to export so that null fields have quotes as qualifiers. 1
Delimited Export Specification - independent of table 3
Generic Export Format 1
Export to Tab delimited text file 4
File Export to CSV 1
Prevent Access from creating double quotes in tab-delimited files 1
Data changes during Export 3
Problems exporting large query results to text delimited format 2

Top