assessing import specs from VBA

  • Thread starter Thread starter Mark VII
  • Start date Start date
M

Mark VII

Greetings --

I just inherited a mess of an Access database, that has a number of import
specs defined. I'd like to loop through all the import specs and for each
spec, write out the particulars for each field. Something like this
psuedocode:

For each ImportSpec in CurrentDb
For each Field in ImportSpec.Fields
'* write ImportSpec Name, Field Name, Data Type, Length to external file

next field
next ImportSpec

The catch is that I haven't been able to find an ImportSpec collection that
I can enumerate to write out this info.

Any thoughts? Am I down to poking around in system tables?

TIA,
Mark
 
Yes, I believe you are relegated to using the system tables. The specific
ones you want are MSysIMEXSpecs (which has one row for each saved spec) and
MSysIMEXColumns (which has one row for each column in each spec).

If you're concerned about using the undocumented system tables, you might be
reassured by reading what MichKa has at
http://www.trigeminal.com/usenet/usenet017.asp
 
Back
Top