>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...
Try 39 instead and also use DisplayAlerts = .f. I haven't tried it myself, though to save as Excel, not CSV.
If it's not broken, fix it until it is.
My Blog