- Joined
- Nov 12, 2007
- Messages
- 2
- Reaction score
- 0
I am attempting to use the TransferText action in Access.
I have tried in Visual basic and get the error when I try to run the DoCmd.TransferText action.
"The Text file specification "Import Orders" does not exist...."
I have confirmed that the import specificaiton works when run manually.
I have placed the specification name in literally and as a variable.
The specification uses the first line of the file to define the field names
and the number of names matches the number of fields.
When I decided to try a macro, my list of macro actions stops at "Stop Macro"
Can you give me ideas how to solve either or both problems.
Thanks,
Faith
I have tried in Visual basic and get the error when I try to run the DoCmd.TransferText action.
"The Text file specification "Import Orders" does not exist...."
I have confirmed that the import specificaiton works when run manually.
I have placed the specification name in literally and as a variable.
The specification uses the first line of the file to define the field names
and the number of names matches the number of fields.
When I decided to try a macro, my list of macro actions stops at "Stop Macro"
Can you give me ideas how to solve either or both problems.
Thanks,
Faith