How to get text qualifiers around empty fields in an export to CSV

  • Thread starter Thread starter Microsoft.com
  • Start date Start date
M

Microsoft.com

I have an access table (first name, middle initial, last name). I need to
export the table into a CSV file with " delimiters on EVERY field. Access
is choosing not to include the quotes around empty fields.

In short, this throws off another program I have that imports the CSV file.
Does anyone know how I can get the "" around empty files.

NOW the export file looks like this
"John",,"Doe"

I NEED IT TO LOOK LIKE THIS
John","","Doe"

many thanks.
(e-mail address removed)
 
Here's one way.

Create a query and export that. In the query, use the NZ() function in
calculated fields to replace any Null values with empty strings. In the
query design grid they will look like this:

fMyField: Nz([MyField], "")
 
Back
Top