File Export to CSV

C

celine

When exporting file to csv the Null values are not shown with the delimiter.
Anyone know how to Export Null Fields to Delimited-Text Format Files?
 
A

Allen Browne

celine said:
When exporting file to csv the Null values are not shown with the
delimiter.
Anyone know how to Export Null Fields to Delimited-Text Format Files?
Click to expand...

Perhaps you could try using Nz() to get a zero-length string, by typing an
expression like this into the Field row in query design:
Nz([YourTextFieldNameHere], "")
and then exporting the query.

Untested. See how you go.
 

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 using wrong format 0
Export Access Query to a pipe delimited .csv file 5
Export to csv 6
CSV file losing "#" in column headers 1
Remove time from date upon export to csv 9
date format problems with export to csv 1
Text Only - Fixed Width Files 1
export query to delimited csv file 3

Top