Open one of your CSV files in Notepad and you will see the problem. It is essentially a one record CSV file. If this is truly the case, more code is needed to split the file into the proper number of columns with added vbCrLf characters to demarcate the "records".