view import specifications

[Droman]

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

 

[fuzzygeek]

Query

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.

 

[Droman]

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

Thank you fuzzygeek that did it!

 

[bairdn]

Good one FuzzyGeek - thanks heaps, you've just saved me a lot of time!

 

[gqnerd]

Re: Query This was excellent thank you

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.

Re: Query This was excellent thank you