R
richard goodwin via AccessMonster.com
I am trying to export a query to a csv file using a schema.ini file in Access 2000.
I have to use this method because I require the output to be to 4 decimal places and my machine is locked down so I cannot change its settings.
The problem I am having is that I also require text qualifier to be set to 'none'. However, when I use the "none" string in the .ini as described by microsoft, I still get text in double quotes.
Schema.ini settings:
[TEST NONE.TXT]
ColNameHeader=True
CharacterSet=1252
Format=CSVDelimited
DecimalSymbol=.
NumberDigits=4
TextDelimeter="none"
Is there something that I am doing wrong or is this another problem with the software?
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=7d98305fa02a4fbbb3e8923eca529cbc
*****************************************
I have to use this method because I require the output to be to 4 decimal places and my machine is locked down so I cannot change its settings.
The problem I am having is that I also require text qualifier to be set to 'none'. However, when I use the "none" string in the .ini as described by microsoft, I still get text in double quotes.
Schema.ini settings:
[TEST NONE.TXT]
ColNameHeader=True
CharacterSet=1252
Format=CSVDelimited
DecimalSymbol=.
NumberDigits=4
TextDelimeter="none"
Is there something that I am doing wrong or is this another problem with the software?
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=7d98305fa02a4fbbb3e8923eca529cbc
*****************************************