Export to CSV without text qualifiers

[wxajb]

I have a simple DB that I'm trying to output to a .txt file (CSV) but without the "'s around the text (qualifiers). I know how to do it manually, but I'm trying to create a button on a form that a user can click and have the user-input data exported to a file that fits the aforementioned criteria. I've looked through all the built in features and came close, but couldn't get it just right, which leads me to think I might need VBScript, which I know nothin about.

Can anyone help me?

Best,
wxajb

 

[pbaldy]

You should be able to export it manually, and create a specification (Save As after the Advanced button). Then you should be able to specify that named specification as one of the arguments of TransferText.

 

[Peter Bellamy]

Do you mean a table within the dB?

If so do it manaully first and use the Advanced button in the Wizard, this will give you the opportunity to save without quotes and save the parameters to use later in your code.

pnb