Combine CSV's from Folder

[Craigc3814]

I have about 10-15 CSV files stored on a network folder that I want to combine. When I try to do so it is throwing this error

DataFormat.Error: There were more columns in the result than expected.
Details:
Count=7

I believe this is because there are now commas on the csv file. The database I am downloading from exports it as a CSV file but its really just an .xlsx (it does not give me the option to export any other way).

I know I can go in and convert each file to .xlsx and make it work but it kind of ruins the automation portion.

I have been searching for about 2 hours with no fix. Does anyone have any ideas?

 

[Joe4]

The database I am downloading from exports it as a CSV file but its really just an .xlsx

What are you basing that statement on?
I only ask because by default, Microsoft sets Excel as the default program to open CSV files (which I absolutely hate that they do this!).
So I just want to make sure that you aren't saying this because you are going out to Windows Explorer and double-clicking on the file, and it is opening it in Excel (does not necessarily mean that it is an Excel file).
The true test is to see what it looks like if you open it with a Text Editor like NotePad or WordPad. If it looks like a legible text file, then it is not an Excel file. If it really is an Excel file, when you go to open it up with a Text Editor, it will look like a bunch of goobledy-gook.