Printing File Specs

[mrabrams2]

Is there a way to print the Import File Specifications out of Access?

WINXP-ACC97

Thank you.

 

[Pat Hartman]

You'll have to do some dective work but the data you need is stored in the mSysIMEXSpecs and mSysIMEXColumns tables.

I am not aware of any collection that holds this information but if you can find one, using the collection would be better. Microsoft does not recommend using the mSys tables because since they are not "exposed" to the public, they may change from version to version and any functionality you built that references them may fail to work in the next version of Access.

 

[mrabrams2]

I will investigate the mSysIMEXSpecs and mSysIMEXColumns tables as you mentioned.
Thank you.

 

[fuzzygeek]

Remember that they are system tables. As a start, try this sql:

SELECT MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName
FROM MSysIMEXSpecs LEFT JOIN MSysIMEXColumns ON MSysIMEXSpecs.SpecID = MSysIMEXColumns.SpecID;

 

[mrabrams2]

Got it !!

Ya beat me by a few minutes there fuzzygeek !!

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


I added a couple of columns and VOILA! Just what we need !!

Thank you !!