Export to CSV using Schema.ini with no text qualifier

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richard goodwin - 13 Oct 2004 17:26 GMT

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?

Reply to this Message

mr - 13 Oct 2004 18:53 GMT

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]
[quoted text clipped - 12 lines]
> * Report spam or abuse by clicking the following URL:
> *

http://www.accessmonster.com/Uwe/Abuse.aspx?aid=7d98305fa02a4fbbb3e8923eca529cbc

> *****************************************

Reply to this Message

richard goodwin - 13 Oct 2004 19:31 GMT

Thanks for that.

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

Reply to this Message

mr - 13 Oct 2004 20:00 GMT

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

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

> Thanks for that.
>
[quoted text clipped - 6 lines]
> * Report spam or abuse by clicking the following URL:
> *

http://www.accessmonster.com/Uwe/Abuse.aspx?aid=e95442f82d51422da141958b2f3ccece

> *****************************************

Reply to this Message