Can anyone tell me how to view import specs that are currently defined in access?

Make a new query. Drop the following code in the SQL part.

SELECT MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName, MSysIMEXColumns.Start, MSysIMEXColumns.Width, MSysIMEXColumns.SkipColumn
FROM MSysIMEXColumns INNER JOIN MSysIMEXSpecs ON MSysIMEXColumns.SpecID = MSysIMEXSpecs.SpecID
ORDER BY MSysIMEXSpecs.SpecName, MSysIMEXColumns.Start, MSysIMEXColumns.Width;



These table are not updatable by you, but will show the Spec, the fields, the start and the width.

I revised the query to show skipped fields and to sort properly.

Originally posted by Droman
Can anyone tell me how to view import specs that are currently defined in access?


Thank you fuzzygeek that did it!