Missing quotes on blank fields in export results file

[NumbersMan]

When exporting from Access to a comma delimted file with text qualifiers as
set as quotations marks, the empty fields are not surrounded by the quotation
marks in the rsult export.txt file. The odd thing is that in the export
wizard, the quotes surround the empty fields but in the actual results file,
they are missing. How can I get the quotation marks to appear on empty fields?

 

[John Nurick]

The only time the text qualifiers in CSV files are significant is when the
data in the field contains a comma or a quotation mark. In other
circumstances - such as an empty field - well-behaved software doesn't care
whether or not the text qualifiers are present.

If you're stuck with a rude import routine, you can create a query that uses
calculated fields like this:
fTextField: """" & Nz([TextField], "") & """"
to enclose each text field in quotes, and then export the query to a
comma-delimited file _without_ setting text qualifiers in the export wizard.

 

[NumbersMan]

John,

Thanks. That rude program is ACT!2006.

J

The only time the text qualifiers in CSV files are significant is when the
data in the field contains a comma or a quotation mark. In other
circumstances - such as an empty field - well-behaved software doesn't care
whether or not the text qualifiers are present.

If you're stuck with a rude import routine, you can create a query that uses
calculated fields like this:
fTextField: """" & Nz([TextField], "") & """"
to enclose each text field in quotes, and then export the query to a
comma-delimited file _without_ setting text qualifiers in the export wizard.

When exporting from Access to a comma delimted file with text qualifiers
as
set as quotations marks, the empty fields are not surrounded by the
quotation
marks in the rsult export.txt file. The odd thing is that in the export
wizard, the quotes surround the empty fields but in the actual results
file,
they are missing. How can I get the quotation marks to appear on empty
fields?

 

[John Nurick]

John,

Thanks. That rude program is ACT!2006.

We all know that fame doesn't always bring politeness!