MS Access Import/Export Specifications
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.