bobaol
Board Regular
- Joined
- Jun 3, 2002
- Messages
- 225
- Office Version
- 365
- 2003 or older
- Platform
- Windows
Hi, I am trying to do the following on Access using the TransferText Action.
In TransferText Action, Transfer Type =Import Delimited, Specification Name = RC1, Table Name = ABC1, File Name = C:\arc_file1.txt, Has Field Names = NO, HTML Table Name = Blank.
OK, my question. I want to use all the following as described in the above except for File Name = C:\arc_file1.txt because I want to pick and choose my own file. Next month, it will be arc_file2.txt and so on. I know I can use a Command->Import option to get a dialogue box, but that does not allow me to retain Specification Name = RC1. Ok, what is the VB code to get a dialogue box and retain all the other specification as described above for the TransferText Action? Thanks in advance.
In TransferText Action, Transfer Type =Import Delimited, Specification Name = RC1, Table Name = ABC1, File Name = C:\arc_file1.txt, Has Field Names = NO, HTML Table Name = Blank.
OK, my question. I want to use all the following as described in the above except for File Name = C:\arc_file1.txt because I want to pick and choose my own file. Next month, it will be arc_file2.txt and so on. I know I can use a Command->Import option to get a dialogue box, but that does not allow me to retain Specification Name = RC1. Ok, what is the VB code to get a dialogue box and retain all the other specification as described above for the TransferText Action? Thanks in advance.
