assessing import specs from VBA

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
 
D

Douglas J. Steele

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reate relationship as each excel table is imported VBA 1
Import fields from .csv with variable column structure 4
Import Excel into Access using VBA 4
NEWBIE Needs To Import All Records From A Folder 1
Object Definitions from External Db 6
Limit on Import Specs for Fixed Width?? 1
VBA 2
Import Contacts From Excel to Outlook Not Working 3

Top