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

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
 
V

Van T. Dinh

(***not tested***)

Try using the Calculated Field:

NoNullText: Nz([YourField], "")

in the Query and Export this Calculated Field instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfertext enclose number fields in quotes 6
Export data from current record to csv 4
How Do I Export Integer Data And Maintain Leading Zeros? 1
Export to CSV with ; not , 3
export to csv - can t get rid of decimal 3
TransferText using wrong format 0
Create a csv file 11
Export of text field trims leading zeros 1

Top