If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
csv file
How do I put double-quote on each of the field in the CSV file using access
97? Thanks. |
#2
|
|||
|
|||
csv file
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. |
#3
|
|||
|
|||
csv file
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to creat relative and shorthand file path names? | 2dogs | General Discussion | 1 | May 15th, 2005 12:11 PM |
How to create relative and shorthand file path names | 2dogs | General Discussion | 4 | May 14th, 2005 08:49 PM |
Templates | gman | Page Layout | 17 | April 22nd, 2005 06:35 PM |
OLE Object- the real question | Michelle | Using Forms | 18 | February 28th, 2005 04:04 AM |
Continual Error 1321 Trying to Install Office 2003 | Chad Harris | General Discussions | 9 | June 11th, 2004 08:19 AM |