cboshdave
01-08-2016, 02:03 PM
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!
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!