Printing an export spec 1

[KenCunningham]

Hi folks,

a quickie before I leave for the weekend. Is it possible to print a fixed width export specification for examination away from the PC? TIA.

 

[dhookom]

Sure. This information is stored in a couple system tables. Create a query with this sql to get you going:
[tt][red]
SELECT MSysIMEXSpecs.SpecName, MSysIMEXSpecs.FieldSeparator, MSysIMEXSpecs.StartRow, MSysIMEXSpecs.TextDelim, MSysIMEXSpecs.TimeDelim, MSysIMEXColumns.FieldName, MSysIMEXColumns.DataType, MSysIMEXColumns.IndexType, MSysIMEXColumns.SkipColumn, MSysIMEXColumns.Start, MSysIMEXColumns.Width
FROM MSysIMEXColumns INNER JOIN MSysIMEXSpecs ON MSysIMEXColumns.SpecID = MSysIMEXSpecs.SpecID;
[/red][/tt]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[KenCunningham]

Duane, you are a gentleman and a scholar. Many thanks and have a great weekend.