SQLTeam.com | Weblogs | Forums

Load matching name files in tables

i have a folder that contains multiple .csv files for each employee like empname_date.csv and i want to load files in one table.
Not all files but only files where file name matches the data with tbl_empmaster table that contains master list of employees.

i do not want to check each file beacuse it will take too much of time. I need to filter files as per master list and then load the matching employee files.

Please help what can i do in this case.