Why do the last two posts of text file data look nothing like the Excel example data? I downloaded the file and it looks like the Excel and post 8 examples. It is not 'CSV', it is tab-separated. And quote marks surrounding the numeric data. And a 'Total' row that has to be ignored. This text file will have to be 'scrubbed' before the import wizard can deal with. Delete the Total row, replace all commas and quotes with nothing. Then the import works without error.

Otherwise, use VBA code that opens a text file object and reads each line and parses the string to fields.