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

Unreadable text when viewing organization chart in Web version of Visio 365 0
Adding sequence numbers to paragraphs 0
How to export html text as word document with specific size and orientation 0
Template with fields and premade texts.. 0
Delimited Export Specification - independent of table 3
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Address Format changed after Migration 0
Excel does not accept text format! 0

Top