0
-00Eric Clapton
How do I put double-quote on each of the field in the CSV file using access
97? Thanks.
97? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Nurick
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] & """"
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] & """"
P
Pat Hartman\(MVP\)
This happens automatically when you export using the TransferText
Method/Action. Just choose the delimiters you want if they're different
from the default.
Method/Action. Just choose the delimiters you want if they're different
from the default.