How to get ,"", in exported csv file for null or empty fields

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

Guest

Hello!

I'm using 'DoCmd.TransferText acExportDelim' to export a table to a csv file.
I want quotes around my text fields and I am getting that just fine. But I also
need to have null or empty fields exported as: ,"",

Instead, I get: ,,

Is there some way to produce ,"", instead of ,, ?

Thanks,
Tom
 
(***not tested***)

Try using the Calculated Field:

NoNullText: Nz([YourField], "")

in the Query and Export this Calculated Field instead.
 
Back
Top