C
ChuckL
I need to import multiple text files into a table in a
database; not all located in the same directory. All of
the files are formatted the same, however, they each have
a different name (ie: 066610.txt, 001110.txt, etc). I am
running Access 97 and am not great when it comes to
writing code. I am using the TranferText action in a
macro to try and accomplish this task one file at a time.
I want my user to be able to click a command button, on a
form, that prompts them for a file path and file name that
they want to imort. The problem I am facing is that the
File Name (and the path to it)is a required argument in
TransferText action, hence, it must be consistant. I have
already saved import specifications to use when the import
occcurs. I would like to give my users the ability to
choose a file path and file name to import? Is this
possible?
Thanks in advance for any help. It is greatly appreciated.
database; not all located in the same directory. All of
the files are formatted the same, however, they each have
a different name (ie: 066610.txt, 001110.txt, etc). I am
running Access 97 and am not great when it comes to
writing code. I am using the TranferText action in a
macro to try and accomplish this task one file at a time.
I want my user to be able to click a command button, on a
form, that prompts them for a file path and file name that
they want to imort. The problem I am facing is that the
File Name (and the path to it)is a required argument in
TransferText action, hence, it must be consistant. I have
already saved import specifications to use when the import
occcurs. I would like to give my users the ability to
choose a file path and file name to import? Is this
possible?
Thanks in advance for any help. It is greatly appreciated.