Export Text wizard will not start.... how do I create export spec? (1 Viewer)

pungentSapling

NeedHotSauce?
Local time
Today, 06:13
Joined
Apr 4, 2002
Messages
116
I am trying to create a new export spec... problem is that I can not get the Export Text Wizard to fire up so I can not get to to where I need to define and save the new specification.

I am selecting the query I want to export... clicking save as/ export...
then choosing "to external file"....
then save type as: "text files"
then click export...... then wham bang ..it exports the file and I never get a chance to create a new spec.


any help would be greatly appreciated ... I am going crazy.

Access 97

Pung
 

boblarson

Smeghead
Local time
Today, 03:13
Joined
Jan 12, 2001
Messages
32,059
When selecting EXPORT, when the dialog comes up, be sure to type in the extension you want the file to have. For example, I have the table tblOutput and select EXPORT. It will show up as tblOutput in the file name. Select the .txt,.csv,etc. file type and then also type in the extension you want. For example if I want .txt after my tblOutput, then I add the .txt to tblOutput to get the file name of tblOutput.txt. Then you will get the dialog where you can set your delimiters, and where you can go into ADVANCED to create an Export Specification.
 

Users who are viewing this thread

Top Bottom