transfer import/Export specification into access 2003

Need to apply the same import specs to mutiple access databases. What the best way to transfer import specification into different access 2003?

Thanks in advance.
rowfeiAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
from the db you want to use the import/export spec << database B

file >get external data>import
select the the db with the import /export spec then click import << database A

click Options from the impoer objects window

Uncheck Relationship from the import options and check Import/Export specs

then click Ok
0
 
Chuck WoodCommented:
Begin as if you were going to import a table, form, etc.
When you get to the Import Objects dialog box, select Options >> and click the Import/Export Specs check box.
0
 
Rey Obrero (Capricorn1)Commented:

from the db you want to use the import/export spec

file >get external data>import
select the the db with the import /export spec then click import

click Options from the impoer objects window

Uncheck Relationship from the import options and check Import/Export specs

then click Ok
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
rowfeiAuthor Commented:
How can I copy the Import/Export specs from database A to database B?
0
 
Chuck WoodConnect With a Mentor Commented:
Goto database B and follow the instructions capricorn1 just posted.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
FWIW, You can also go the low tech way and copy the records between the system tables MSysIMEXSpecs and MSysIMEXColumns if you want to do it programatically, but I would use the interface option as cap mentioned if your just doing it manually.  It's simpler and quicker.
JimD.
0
 
rowfeiAuthor Commented:
Hi cwood-wm-corn:

I have another followup question regarding my last post:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24373046.html#a24306716

Can you take a look at?

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.