Importing a Variable File Name
-
I'm having trouble figuring out how to import a file using DTS where the only constant is the extension *.dlt. The name can be anything. Please help if you have an answer.
-
maybe this could help:
if instr(fil.path,".dlt") > 0 then
'**** import this file***
else
'*** Check another file name ***
end if
Be carefull that ".dlt" is not used within the file path but in the filename only.
J
-
Check the articles over at http://www.sqldts.com about changing the text file connection.
--------------------
Colt 45 - the original point and click interface
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply