Missing quotes on blank fields in export results file

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

Guest

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?
 
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.
 
John,

Thanks. That rude program is ACT!2006.

J

John Nurick said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top