Export File Specifications 1

[BDE]

I have saved a number of export file specifications in Access 2000. How can I retrieve a list of these, I cannot access them through documenter.

 

[RickSpr]

Go to the Tools>Options dialog, and on the View tab check the System Objects box. Then go to the tables tab in the database window, and find the table MSysIMEXSpecs. Within that table, the SpecName column lists your import and export specifications. You may also find some specifications that Access created in the background.

The MSysIMEXSpecs table can be used as input to a query, or accessed from code if you need it. If all you want is to view a list, you can just start a dummy import (or export), select the file type, and when you get to the wizard click the Advanced button to open the Import (or Export) Specification dialog. Click the Specs button there to get a list of the current specs. Cancel the import/export when you're done looking at the list. Rick Sprague