Import Text Wizard Specification template, import/copy from one mdb to another?

[Kevin]

I created a specification template to parse a text file in a test mdb. The
specification templates are seen/created when using the Import Text Wizard,
Advanced button.. Anyway, I am placing my code into another mdb and I'd
like to import the specification template I created. It's failry large and
I'd like to avoid re-typing it. Is there a way to copy or import these spec
templates?

Thanks for any tips!

Kevin

 

[Nikos Yannacopoulos]

Kevin,

The import/export specs are saved in system tables which are not directly
accessible, so I don't think there is a way to export them directly, I
thought of a trick that might do the job, I haven't tried it but it's fast
and easy to do and stands good chances to work, so you might want to give it
a shot: make a copy of the test mdb that has the spec, delete all objects
and import all objects from your working mdb; chances are the spec will
still be there.

HTH,
Nikos

 

[Kevin]

Thanks that worked! Great tip!

Kevin

Kevin,

The import/export specs are saved in system tables which are not directly
accessible, so I don't think there is a way to export them directly, I
thought of a trick that might do the job, I haven't tried it but it's fast
and easy to do and stands good chances to work, so you might want to give it
a shot: make a copy of the test mdb that has the spec, delete all objects
and import all objects from your working mdb; chances are the spec will
still be there.

HTH,
Nikos

 

[MacDermott]

If you go to File - Get External Data - Import Table, there's an Advanced
tab which lets you select to import import/export specifications.

HTH