How do I export an Access table to include "" for empty columns ?

[Guest]

When I export a table to a comma delimted text file using " as the text
identifier, I need to have empty columns display as "" in the text file.
When I run through the export wizard, the repeating double quotes are shown -
but when I open the .txt file after the export, I do not have the "".

 

[Nikos Yannacopoulos]

That's because "empties" are Nulls, which is different to zero-length
strings - the latter is what you are asking to export. An easy way
around it is to build a simple query on the table, and use calculated
fields with the Nz() function instead of the original fields where you
need the substitution, like:

Field1_Alias: Nz([Field1], "")

where Field1_Alias can be any alias you like, and Field1 is the name of
the field.
The export the query instead of the table itself, and the job is done.

HTH,
Nikos