MS Access Import/Export Specifications
Have you ever wondered where MS Access stores the Import/Export specifications that you create? Have you ever tried to figure out how to export, document, or change them? After inheriting an MS Access application I needed to locate, document and change an existing export specification.
Microsoft Access stores Import and Export Specifications in two system tables:
These tables can be joined using the SpecID column. Here is a handy piece of SQL code you can execute from within Access itself to extract the specification of your choice.
SELECT MSysIMEXSpecs.SpecName, MSysIMexColumns.* FROM MSysIMEXSpecs LEFT JOIN MSysIMEXColumns ON MSysIMEXSpecs.SpecID = MSysIMEXColumns.SpecID WHERE SpecName = 'MySpecName' ORDER BY MSysIMEXSpecs.SpecID, MSysIMEXColumns.Start;
If you happen to be handy with SQL you can make changes to a specification and adjust existing fields or add new fields by executing SQL statements against these same tables. This can be much easier than recreating a specification from scratch.