Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to check if file exsists

Status
Not open for further replies.
MikeTom

MikeTom

Programmer
Aug 17, 2001
98
0
0
GB
I have an import DTS routine in visual basic that imports data from andn excel file to sql. How can i check if the file exists in the directory before i run the routine.

Thanks in advance.
 
Sort by date Sort by votes

One way is...
[tt]
If Dir(PathFileName) = vbNullString Then MsgBox "File Does Not Exist"
[/tt]

Good Luck

 
Upvote 0 Downvote
For reference... you can also use the FileSystemObject, which has a FileExists method.

:-D
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
163
strongm
strongm
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
108
strongm
strongm
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
131
Ken01
Ken01
sal21
  • Locked
  • Question
read xml file 1
Replies
9
Views
126
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
check if i have clicked on header column name GIORNI 1
Replies
8
Views
114
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top