Export to CSV using Schema.ini with no text qualifier

[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
*****************************************

 

[mr]

TextDelimiter is spelt incorrectly in your file. I just ran this with it
correctly spelt and it works fine.

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
*****************************************

 

[richard goodwin via AccessMonster.com]

Thanks for that.

It sometimes takes a fresh pair of eyes to spot a problem with the fingers!

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/uwe/Forum.aspx/access-externaldata/6846
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=e95442f82d51422da141958b2f3ccece
*****************************************

 

[mr]

tell me about it . I do that all the time.

Thanks for you answer to my question as well.
It worked out great!