How to Export Null Fields to Delimited-Text Format Files in Access ZAPPER 12/31/2008 12:10:06 AM In doing an export, I need to have null fields show quotes. Example... ,"data", "test","","","moredate" Can anyone help with this?

Re: How to Export Null Fields to Delimited-Text Format Files in Access "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 12/31/2008 12:32:49 AM Create a query, and rather than showing the field, use a calculated value of Nz(MyField, """"""") (That's 6 double quotes in a row.) Export the query, not the table. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "ZAPPER" <ZAPPER[ at ]discussions.microsoft.com> wrote in message news:3D19048A-DAD0-4C97-8B66-CD8ECBD0D2F2[ at ]microsoft.com... [Quoted Text] > In doing an export, I need to have null fields show quotes. Example... > ,"data", "test","","","moredate" Can anyone help with this?