csv file

How do I put double-quote on each of the field in the CSV file using access
97? Thanks.

Hi Eric,

Assuming that you're exporting data to CSV: the export system defaults
to enclosing all text fields in quotes, so you only have to deal with
non-text fields.

So

1) export a query rather than a table

2) use calculated fields in the query to convert numeric and date/time
values into text, e.g.

fMyNumber: Format([MyNumber], "0.000")
fMyDate: Format([MyDate], "dd/mm/yyyy")

Alternatively, concatenate the fields with double quotes:

fMyNumber: """" & [MyNumber] & """"

On Mon, 7 Nov 2005 13:00:40 +0800, " -00Eric Clapton" wrote:


How do I put double-quote on each of the field in the CSV file using access
97? Thanks.



--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

This happens automatically when you export using the TransferText
Method/Action. Just choose the delimiters you want if they're different
from the default.

" -00Eric Clapton" wrote in message
...
How do I put double-quote on each of the field in the CSV file using
access 97? Thanks.