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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 "".
 
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
 
Back
Top