Question Using Import Specification on other machine

[mcdhappy80]

I've created Import Specification in my database and I need to use it on the other machine. How do I move it on other machine?

Thank You

P.S. - I've created two import specifications in my database and none of them is listed when I click on External Data -> Saved Imports. The only place I can see them is External Data -> Import Text -> Link To Data Source -> Advanced -> Specs

 

[Galaxiom]

In Access 2007 they are recorded in System tables called MSysIMEXColumns and MSysIMEXSpecs.

Right click the Navigation bar and choose Navigations Options.
Turn on Show System Objects.
Copy these tables to the destination database.

If you already have Import specs in the new database which you wish to preserve, import the tables from the original database. Copy the tables with another name or import them. The system tables from other databases will be will be available in the Import if Show System Tables is enabled in the destination database.

Make a query to append the entries to the spec tables in the destination database. You will need to adjust the query to resolve key field conflicts with the SpecID field.

 

[mcdhappy80]

Thanks for giving me a start point. I will definitively try this and post if I have some problems.