FTP Corrupting .csv file

[DevelopV]

I am downloading .csv files from the Internet using FTP (VBA Code). The FTP code can be viewed here:
http://tek-tips.com/viewthread.cfm?qid=1703957

The file is getting corrupt during the transfer!
The file on the ftp server looks like this:
CustomerID,CustomerName,PhysicalAddress1,PhysicalAddress2,PhysicalAddress3,PhysicalAreaId,CustomerStatusId,TradePrice,Telephone
2099395,"Donald’s Hair Salon","55 Talana Road",,Claremont,256,1,0,0217970028

The file on my PC looks like this:
CustomerID,CustomerName,PhysicalAddress1,PhysicalAddress2,PhysicalAddress3,PhysicalAreaId,CustomerStatusId,TradePrice,Telephone
2099395,"Donald’s Hair Salon","55 Talana Road",,Claremont,256,1,0,0217970028d,TradePrice,Telephone
2099395,"Donald’s Hair Salon","55 Talana Road",,Claremont,256,1,0,02179

I am downloading the file as "ASCII"

What can cause this?

BTW if I transfer the file using FileZilla the downloaded file is the same as the original

 

[PHV]

Did you try to download as BINARY ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DevelopV]

Thanks but Binary does not help

 

[strongm]

Tum ti tum

 

[strongm]

(by which I mean that it is a shame that the shell-based FTP solution didn't work for you)