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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Microsoft.com - 02 Aug 2004 15:18 GMT

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.
admin@mcsinfotech.com

Reply to this Message

John Nurick - 02 Aug 2004 19:43 GMT

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], "")

>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
[quoted text clipped - 11 lines]
>many thanks.
>admin@mcsinfotech.com

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message