Check for file before import?

A

AirgasRob

Using Access 2000 with WindowsXP

I am importing a text file using DoCmd.TransferText, is their way to have
access check to see if the file is there first?

I import four text files at a time and would like some kind of check to make
sure all four are there before starting the whole sequence.

All suggestions appreciated.
 
K

Klatuu

You could use the Dir() function to see if the files exist. Look how up to
use it in VBA Help.
 
Top