How to export so that null fields have quotes as qualifiers.

[Dan]

I am exporting a table in comma delimited format with quotes as qualifiers.
All of the fields in my access table are defined as text. I need to have all
the fields contents in quotes, even fields with null values. While in the
exporting dialog box I select the advance button and set the properties they
way I need. At the last step of the wizard it looks like null values have
quotes but when I open the exported file the fields are delimited by only the
fields with values have quotes.

How can I export all the fields so they have quote marks around them whether
there is data or a null value?

 

[Ken Snell [MVP]]

You'll need to create a query that is based on the table. In that query,
instead of using the text fields from the table directly, use calculated
fields that use the Nz function to replace Null with an empty string:

MyExportField: Nz([FieldName], "")

Do this for each field, using a different name than MyExportField (each
calculated field needs a unique name).

Then export the query instead of the table.