Export query question

  • Thread starter Thread starter Bob Hughes
  • Start date Start date
B

Bob Hughes

I have a query I export to a csv file using a ',' delimiter and text
qualifier ". They are all text fields. I need the blank text fields to
contain ,"", not ,, as I get now. Can anyone suggest a way of doing this?
Bob
 
I would try the Nz function in your query to set the nulls to zero-length
strings.

SELECT NZ(MyTextField,"") as My_TextField, SomeNumberField, ...
FROM YourTable
WHERE ...

I don't know that using Nz will work, but I suspect it will.
 
I would try the Nz function in your query to set the nulls to
zero-length strings.

SELECT NZ(MyTextField,"") as My_TextField, SomeNumberField, ...
FROM YourTable
WHERE ...

I don't know that using Nz will work, but I suspect it will.
Click to expand...

It turned out to be my table design and not setting a default value. So I
set Allow Zero Length to true & set default value to "". Everything is
working now.
Thanks for your help.
Bob
 
Back
Top