Where are import and export specs in Access? (Interpreting inherited code)

[cboshdave]

I realize this is a dumb question. But I cannot seem to interpret these two lines of some code I have inherited and now need to support.

I understand that the following line imports a fixed length file defined in the text27 box and pulls it into Group_Import table. But how can I modify the "GroupImportSpec" that tells where the fields split up?? I don't know where this is or how to modify it??


DoCmd.TransferText acImportFixed, "GroupImportSpec", "Group_Import", Me!Text27


The answers are probably similar for both of these lines. I am trying to find how to modify Group_Export as well.
On this line, I see a Query called Q-GroupForAIR and the table, but not the instructions for exporting.


DoCmd.TransferText acExportDelim, "Group_Export", "Q-GroupForAIR", Me!Text38

Sorry for the dumb question. Just stumped!

[jonh]

It's not a dumb question at all.

Like most things in access, specs are stored in a msys... table.


Master msys table being msysobjects


either show system tables or write a query



select * from msysobjects


you'll probably be interested in looking @


MSysIMEXSpecs
MSysIMEXColumns


but from past experience it's probably easier to just run through the wizard and save a new named spec.