I have an ongoing need to import text files that were output from another application into an Access table. I will be doing this using VBA code. I know which folder these files will be in, and the file extension. Once each file has been imported I will rename it from something.PTX to something.XTP so that the file is retained but will be ignored by future imports.
The problem I have is that I will never know the file names, and there could be any number of them.
So essentially what I need to do is loop through the following:
open the first file I encounter in the folder with an extension of .PTX
import it
rename it
until no files with a .PTX extension remain.
I have no idea how to open a file for import within Access without knowing its name. Can anyone advise me how to go about this please?
Many thanks in advance.
Cathy
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar