>Thanks Josh, but I am a begginer here. If my directory with all the files is C:\DATA would I insert that where you have the DIR and also do I declare the variable for the files first, and if so how ?


right; instead of "CD ImportDir" you'd issue "cd c:\data"
and Adir (not just dir) comes after.

You do not need to declare the vars first; but you can, as Ko has already discussed.