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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel CSV Files; Creating Of 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Multiple OU's in csvde 0
Access Importing csv daily files into access 2007 1
.csv Commas ? 2
How to export Access data to Quickbook? 4
Which is the best MBOX Converter Tool different formats conversion? 4
How can I import to Access 2003 from csv-file via VBA? 4

Back
Top