Export txt Wizard - export spec

[Woland81]

Hello, All,

I need to export the results of a query into a .txt file in a particular format: it should be delimited and some of the fileds should have "" around them and some should not. I could not figure out how to do this. help.

btw, have i got it right that you can not export a query using spec?

thanks

 

[Ron_dK]

Export query :

Go to File → export → select save as type : text files ( *.txt;*.csv; *.tab;*.asc ) and you'll get the export text wizard. Click the button "advanced" and you'll be able to configure the export specification.

 

[Woland81]

Yeah... that's what help says. The problem is that it does not run the wizard for some reason if I try to export a query. It just exports it the way it wants without asking me (( there must be some bug in my Access or smth...

 

[Ron_dK]

Woland

Please note that one can select two types of text in the "save as type" selector :
Text files ( *.txt etc etc)
or
Microsoft word merge(*.txt).
The first one gives you the advanced button ( configure the export specification) the second one simply exports to a word document. ( No spec).

Ain't got this from help but just configured various specs myself and came to this conclusion.

I'm using Access 2003 , Win XP


PS.
The help function in access says 'if the wizard doesn't start' :

This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled.


Hope this helps.

 

[idp49]

Hi all,

I read about youre problem with the export of data to a .txt or .csv file format. You may find it interesting to take a look at the command DoCmd.TransferText, this allows you the use of predefined import and export specs. Hope it will help.

Greetings