
Recently needed to import 4,000 plus text files into SQL. This was an easy job as: All files were in the same directory All files had the same csv structure. All files had the same file name except for a changing date suffix (eg: 20140131.txt) For the following code to work, you need to have previously set up a date table (tDate) and a … [Continue reading...]