Am I right if I assume that each of the Import Specification files that I've defined are inside the actual .mdb file?

Now I'd like to, through the use of VBA, display the list of the current Import Specification files, and let the user choose which is the applicaple (or none) to the file he wants to import.

Is this possible?

Reenen

:eek:

(I just like the pic)

The spec name, and some information relating to the spec itself, is stored in the system table MSysIMEXSpecs, and if you also need column specification, that's in the system table MSysIMEXColumns (join by SpecID).

I haven't used this for anything yet, so I can't contribute any further, but does this give you a step in the direction you need?

I believe five out of four people have a problem with fractions.


And ten out of eight don't understand the meaning of a "lowest common denominator" :p

Yes! This is exactly what I wanted to know.

Thanks a million! :cool: