Exporting a File Import/Export Specification

[marv_7]

Grettings, Is there a simple way to import/export a "File Import
Specification" from one mdb to another mdb?
Thanks, Harv

 

[Mike Labosh]

Grettings, Is there a simple way to import/export a "File Import

Specification" from one mdb to another mdb?

There are two hidden / system tables, MSysIMEXSpecs and MSysIMEXColumns.
This is where Access stores yoiur import / export specifications. If you
can't see them, you'll need to visit the Options dialog and set a checkbox
to show the hidden objects.

Then you can either export them, or query to find the records of interest,
and export the results of the query.

--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"

 

[Brian]

Grettings, Is there a simple way to import/export a "File Import
Specification" from one mdb to another mdb?
Thanks, Harv

Yes. In the Import Objects dialog box, click the Advanced button. There's
a check box for Import/Export specs.