'Advanced' option with export wizard

[Fredrated]

Can someone refresh my memory on where this is found?

When I open a table or query and choose File>Export, which is where I
thought it could be found, all i get is 'file type' and 'file name' boxes and
an 'export all' button. Export all then proceeds to export the data, with
none of the options like 'delimited with...', 'advanced' etc. I was
expecting. I want to create an export specification, but can't seem to
remember where this option is found.

Alternately, could someone explain how to import an import/export file
specification? When I use File>Get external data>import, navigate to the
database with the file spec I want, choose 'options' and check 'import/export
specs', then OK, it seems that nothing is imported, because my export routine
reports that the file spec is not found.

Thanks in advance for any help

Fred

 

[Joan Wild]

: Can someone refresh my memory on where this is found?
:
: When I open a table or query and choose File>Export, which is where I
: thought it could be found, all i get is 'file type' and 'file name' boxes and
: an 'export all' button. Export all then proceeds to export the data, with
: none of the options like 'delimited with...', 'advanced' etc. I was
: expecting. I want to create an export specification, but can't seem to
: remember where this option is found.

When you choose a file type (such as txt), and click Export, then the export wizard starts and that is where you can setup/save an export spec.

: Alternately, could someone explain how to import an import/export file
: specification? When I use File>Get external data>import, navigate to the
: database with the file spec I want, choose 'options' and check 'import/export
: specs', then OK, it seems that nothing is imported, because my export routine
: reports that the file spec is not found.

That sounds as though either the database that you think has a spec, doesn't have one, or

that you've mistyped the name of the file spec in your code. If you go to File, Get External Data, Import and choose 'text' file type, and select some file, you can then get the wizard started; choose Advanced and click on Specs and verify the name of the spec (you can cancel the import).