We need to do this all the time. This is just one example of a way to load multiple Excel data files into a table.
http://www.sqlservercentral.com/articles/OPENROWSET/163645/
The same concept could be used to load flat files.
We need to do this all the time. This is just one example of a way to load multiple Excel data files into a table.
http://www.sqlservercentral.com/articles/OPENROWSET/163645/
The same concept could be used to load flat files.