How to read a big file list from a textfile to form a query
I have this query which I have to run multiple times in excel and i need
to change the filelists in it.
select * from files
where
filename in ('filename1','filename2')
so I have a TEMP in my query filename in TEMP and I want to loop and get
the result for all filelists. My onlyproblem is reading .txt into the TEMP
and executing the query once for all filenames in the txt file. i know how
to read files line by line so that didn't help.
my text files which I want to read the lists from are like
filename1 filename2 . . . . filename15000
yes some big numbers.
No comments:
Post a Comment