Import specification, how to copy it

[Chris L.]

Hello,

I've generated a TXT import specification (by pressing "advanced"
button when importing), how do I copy it to another computer? I need
to use the spec to import the same TXT file on other mdb's. What
file(s) should I copy?

Thanks in advance
C.

 

[Roger Carlson]

In the new database, you can import it from the old.

Go to File>Get External Data >Import. Then choose the old database. Now,
click the Tables tab. At the bottom, there is an Options button which will
allow you to import Import/Export Specs.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[George Nicholson]

There may be a more direct way to do this by importing a system table (where
I believe Specs are stored), but this will do it too.

- Open the mdb file you want to import the spec into.
- File>GetExternalData>Import, and point to the mdb file (or copy of) that
has the spec u want

- ImportObjects Dialog: 1) Select an object from the external mdb (table,
query, form). Even if you don't really want to import anything, you have to
select something afaik.
- ImportObjects Dialog: 2) Click Options, then check "Import/Export Specs"
- ImportObjects Dialog: 3) Click OK

That should do it.

(Optional)
- Delete the object you selected for importing if you don't really want
it in that file
- Compact

HTH,