I had never used the
External Data, New Data Source, From File, Text File and save the import steps before. Is that what you are referencing in the VBA with the param "CSV_Import_Specification"?
Also, now that I was able to get past the "-" being in the zip code fields, I discovered that some rows have a page break which just ruins the data import. Today I feel like I overcame one error just to uncover a new one.
Here is a sample spreadsheet that illustrates what I mean.
http://www.filedropper.com/book1-2