I thought about what you all were saying about preprocessing the file, and I looked at Nadia's string from way back again....

Could I do something like this:

>loExcel = CREATEOBJECT("Excel.Application")
>loExcel.Workbooks.Open("theoriginalcsv.csv") && Secretly open the csv that I downloaded
>loExcel.Workbooks.SaveAS("thenewcsvthatworks.csv",8) && Now, save it to ANOTHER csv, but with Excel
>loExcel.Workbooks.Close(0) && Close, do not keep changes
>loExcel.Quit


and then try appending??

My problem seems to be with the third line of code.....I think the number 8 needs to be changed to something else...