Importing Import/Export Specs

[mtairhead]

Is there a way to move import/export specifications from one database to another?

 

[RoyVidar]

When importing (File | Get External data | Import) hit the Option Button, and check the Import/Export Specs checkbox.

 

[mtairhead]

Thank you!

 

[mtairhead]

Say - Can you do this with VBA by any chance? Can we import and delete Import/Export specs?

 

[Moniker]

Look into this using the Access built-in help:

DoCmd.TransferDatabase

You can do what you want with VBA code using that.

HTH
~Moniker

 

[mtairhead]

Excuse my ignorance, but I don't know what you mean. Perhaps I'm overlooking it in the help feature? I knew that you can transfer objects from one database to another using that VBA code, however I cannot find how one might use it to transfer an import/export specification.


~Andrew