How do I export an Access table to include "" for empty columns ? dpmilkman 06.06.2006 21:19:01 When I export a table to a comma delimted text file using " as the text identifier, I need to have empty columns display as "" in the text file. When I run through the export wizard, the repeating double quotes are shown - but when I open the .txt file after the export, I do not have the "".

Re: How do I export an Access table to include "" for empty columns ? Nikos Yannacopoulos <nyannacoREMOVETHISBIT[ at ]in.gr> 07.06.2006 08:17:29 That's because "empties" are Nulls, which is different to zero-length strings - the latter is what you are asking to export. An easy way around it is to build a simple query on the table, and use calculated fields with the Nz() function instead of the original fields where you need the substitution, like: Field1_Alias: Nz([Field1], "") where Field1_Alias can be any alias you like, and Field1 is the name of the field. The export the query instead of the table itself, and the job is done. HTH, Nikos