Export to .txt file

[rustyg]

Hi,

I am trying to export a table to a .txt file using a macro. I am doing this to import to it another system. The export works, but when I open the text file all the entries have "inverted commas" on each side. The problem is that becuase the records are all in inverted commas the other system wont accept the data.

So my question:

Is there any way (macro, VBA or other) that I can get the data to be exported to the text file without the inverted commas on each record.

Russ

 

[FoFa]

Set your text qualifer to NONE, sounds like it is set to a single quote (')

 

[rustyg]

Thanks for the reply, and I think you may be right, and I can say for sure if you can tell me where I go to set the text qualifier. I have been looking but cant find it anywhere.

Russ

 

[FoFa]

If you are using the wizard, it is on like the second screen. If you are using a macro or DOCMD to do it, then create an export specification and you can specify it there.

 

[rustyg]

Hi,

Can anyone tell me how to crate an export specification? I cannot work out how. I am using a macro for this transfer.

 

[FoFa]

Easiest way is to do a MANUAL export of the data, then on the WIZARD there is an ADVANCED button (usually bottom left). Click that and it will allow you to create a specification, and save it. Then just use the name you saved it as in your macro.