csv file

  • Thread starter Thread starter -00Eric Clapton
  • Start date Start date
0

-00Eric Clapton

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] & """"
 
This happens automatically when you export using the TransferText
Method/Action. Just choose the delimiters you want if they're different
from the default.
 
Back
Top