Solved

transfer import/Export specification into access 2003

Posted on 2009-05-04
7
474 Views
Last Modified: 2013-11-29
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.
0
Comment
Question by:rowfei
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24299771
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24299801

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
 

Author Comment

by:rowfei
ID: 24299806
How can I copy the Import/Export specs from database A to database B?
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 24299817
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
 
LVL 16

Assisted Solution

by:Chuck Wood
Chuck Wood earned 250 total points
ID: 24299819
Goto database B and follow the instructions capricorn1 just posted.
0
 
LVL 57
ID: 24304173
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
 

Author Comment

by:rowfei
ID: 24306974
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question