For import of csv files i would go for someting like this:

SELECT *

INTO tabelA

FROM OPENROWSET('MSDASQL',

'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\Data;','select * from tabelB.csv')

Thanks for your article. Do you also have a solution for sheet xml imports if the sheet name is change randomly or with a certain string?