check if text files exist before import to tables

[alienscript]

Hi great helpers,

These files have to be in G:/Reports/Data
StorageLocation 11.txt
StorageLocation 12.txt
StorageLocation 13.txt
StorageLocation 14.txt
StorageLocation 15.txt

I have a db (XP Office2003) that have a macro that do "transfertext" to import the above text files to the specific table names. I want to first have a check to validate all the text files exist. If all the text files exists, the macro will proceed to run. If one or some of the text files are found not exists, I want the code to prompt a message on a form to indicate which text files are missing.

For example, if "StorageLocation 11.txt" and "StorageLocation 15.txt" are found missing in G:/Reports/Data , the display message on my form should be like :

These files are missing in folder :
StorageLocation 11.txt
StorageLocation 15.txt

I need a code to do this. Appreciate in advance for any help.
Many thanks.

 

[Oldsoftboss]

Not sure if this will help, but shows how to check if a file exists...

http://www.access-programmers.co.uk/forums/showthread.php?t=63675&highlight=isfile