Try

#DEFINE xlCSVMSDOS 24
* Or
#DEFINE xlCSV 6
* or
#DEFINE xlCSVWindows 23

>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...