Export Question

[Sparky]

Hi,

I am exporting text from a query to a text file and it exports it in the following format :

"1234556","testdata","data"

Is there anyway to get rid of the quotation marks?

Cheers in advance,

Sparky.

[tpfkanep]

In Access2002:

Click on the "Advanced" button and select {None} for Text qualifier.

[Sparky]

Thanks for your reply, but where exactly is that set, because I have looked in the specs section of the export/import, but it hasnt solved the problem.

The other thing is that when I try and export in a different format, I have set it to be Tab between 2 columns rather than comma separated, but it doesnt do it.

Is there something I'm doing wrong, or something obvious which I'm missing?

Cheers,

Sparky.

[tpfkanep]

Access2002:

[tpfkanep]

Access 2002:

[tpfkanep]

Export with <tab>:

[Sparky]

Thanks, thats great!

Cheers,
Sparky.