I have collected the filenames (with complete path) of multiple csv files in a table. Is it possible to use the filename/filepathes of this table to load the files one after the other or choose a specific subset of the files in the table based on e.g. the filedate?
that not exactly what I was thinking of. The table contains the following information (e.g.) Z:\20130701\example1.csv, Z:\20130701\example2.csv, Z:\20130701\example3.csv. in a field called FilenamePath. I would like to use this information to load the mentioned CSV files. So the script should look something like that:
but the information for the FROM statement which csv file to load should come from the existing table with the filename/filepath.