Export / Import Specs

[Newbie]

Access 2002 and Access 2003

I have a database in which I have created some Export / Import specs. I
want to create the same specs in another database.

Is there a way of copying these specs from one database to another? If yes,
how?

Thanks

A

 

[Nikos Yannacopoulos]

Not directly... specs are stored in system tables, which you cannot
write to. You may want to try this trick though: assuming the specs are
in db1.mdb and you want to add them to your (existing) db2.mdb,

1. make a copy of db2.mdb (or rename it to something else)
2. make a new copy of db1.mdb, and rename it to db2.mdb
3. delete all existing objects(tables, queries, forms, reports, macros,
modules) in db2.mdb
4. import all objects from the copy of the original db2.mdb into the new
db2.mdb.

If everything goes well, your new db2.mdb is a copy of the original one,
plus it contains the specs. If not, you still have a copy of the original!

HTH,
Nikos

 

[Ken Snell [MVP]]

Yes.

In the new .mdb file, click File | Get External Data | Import menu. Select
the .mdb file that has the export/import specs in it. Then, when the wizard
window appears, click on the Options button at bottom right of the window.
You'll see a checkbox there for the specs.

 

[Nikos Yannacopoulos]

It was that simple?!!!

Thanks Ken!