Import Spec (1 Viewer)

[Freddy]

For various purposes and reasons, I create separate databases that load in the same set of text files. The record formats of these files are lengthy.

Currently I either copy a database with the spec already in place to a new db and delete the non-relevant tables, queries, etc or retype the entire spec in a new db.

Is there a way I could transfer the import spec from one database to another?

I am using Access 2000. Any assistance is greatly appreciated.

 

[antomack]

You can import specification files from one database to another in the same way as tables, queries, etc. Just use the import wizard as normal and when on the 'Import Objects' screen click on the 'Options' button. This will add a few further options at the end of the screen, one of which is 'Import/Export Specs'. Just tick this and all specifications should be copied over.

 

[Freddy]

Duh - sometimes I get involved in such complex tasks that I forget the simplest ones. Maybe its just burnout. Thanks!