It might be worth checking your Settings/Control Panel/Regional Options/Date format. I guess this is what Excel uses as default when you export a date type column to it. Change dd/MM/yyyy...
In DTS designer, add a "Transform Data Task" object, giving the src as your csv file. After specifying the destination table, got to Transformations, add a new ActiveXScript, click properties,...