I have a table in an Access 2010 DB which I am trying to export into a pipe delimited (|) file with text columns having double quotes around them. When a text column is NULL the double quotes are not being generated in the exported file. The PREVIEW shows them in the output but the final output file doesn't have them in columns which are NULL. Anyone know how to force Access to include the double quotes in the actual output?
I have attached 2 screen shots of a portion of the actual output in a text editor and the previewed output in the Export wizard. All columns shown are text columns.