MSAcces Import File Specifications - How do u enumerate/manipulate

[ttg001]

I am currently trying to put together a job stream document. Vendor provided specs on the file are sketchy and I've done the Import Text File option in Access and have created a series of file specifications (multi record types in source file). Is there a way to programmatically capture the filespecifcation settings? For documentation purposes? for manipulating programatically?

I was envisioning something along the lines of the following collection ...
textfileobject.name(index#).filespecification("NameOfFileSpec").items

But I cannot find the object in any library -- does it even exist?

 

[PHV]

The specifications are stored in the MSysIMEXSpecs and MSysIMEXColumns tables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886