Copy Saved Imports 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.

 

[CJ_London]

What do you mean by saved import?

If you mean the import specification then you need to copy two system files across, MSysIMEXSpecs and MSysIMEXColumns. Applies to 2007 & 2010, I beleive it also applies to earlier versions

 

[Moxioron]

Thank you.

Where would one find those system files?

 

[CJ_London]

Unhide the system tables and you will see them there