Printing File Specs

[mrabrams2]

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

WINXP-ACC97

Thank you.

 

[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 !!