What is specification Name?

[Lina]

I am in the process of creating a macro to export
table into a file, it is asking me for specification
name. What is this and how can I create one?

Thank you,
-Lina

 

[Nikos Yannacopoulos]

Lina,

An Import/Export specification is a set of rules that guide an import or
export process as to the number, type, size, name of fields etc in splitting
a line of text into fields of a record in an Access table, and vice versa.
The only way to create one is to do the process manually once. For an export
specification,
select your table in the database window and go File > Export. Select text
files (*.txt etc), and then just follow the wizzard; and export spec will be
created and saved (internally, in Access system tables). Once it has been
created, you can use it in the macro - just note the name when it's created.

HTH,
Nikos

 

[Steve Schapel]

Lina,

Just to add to what Nikos has said...

The Specification is not created automatically. You have to make it
happen. The easiest way to do this is to run throught the Export
Wizard process manually, and then on the last screen of the wizard,
click the 'Advanced' button. This opens a dialog window where you can
name and save the specification.

 

[Guest]

Nikos,

You said that import/export specs are saved internally in Access system
tables. Is there a way to get at them and print them to have a record of the
import process used?

t.roff

 

[Steve Schapel]

t,

The specifications are stored in the MSysIMEXSpecs and MSysIMEXColumns
tables. These tables can be seen by selecting to show System Objects,
via the View tab under the Tools|Options menu.