Solved

transfer import/Export specification into access 2003

Posted on 2009-05-04
7
471 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

776 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