Copying the Saved Import from one db to another

[Moxioron]

Hello.

I pasted the tables, modules, macros, etc. from one database to another and the only thing left is the Saved Import. How can I get that into another database? It is quite a large import, otherwise i would just recreate it.

Thanks. <!-- / message --><!-- Adsense inside first post-->

 

[SydneyGeek]

Assuming that you are in 2007 or higher...

Access has an ImportExportSpecification object that you can get to in VBA, and retrieve the XML (among other things).
Syntax is Application.ImportExportSpecification("Some named import").XML

When you do an import from the new Db, you should be able to select import/export specifications on one of the options.

Denis