Check for file before import?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You could use the Dir() function to see if the files exist. Look how up to
use it in VBA Help.
 
Back
Top