OK, I looked at the first link, there is no "T", remember that you must open it in some text editor, not Excel, the raw format of the first two rows is:
Date, Conditions, Ext. Temperature,Dew Point,Wind Chill,Pressure,Wind Speed (10 Min. Average),Average Wind Direction,Precipitation Per Hour,Precipitation Total,Ext. Humidity,Int. Humidity,Int. Temperature,Wind Gust (10 Mins),Solar Radiation,UV Index,Leaf Wetness 1,Leaf Wetness 4,Soil Moisture 1,Soil Moisture 2,Soil Moisture 4,Leaf Temperature 1,Leaf Temperature 2,Soil Temperature 1,Soil Temperature 2,Soil Temperature 4,Monthly Rain,Annual Rain,Daily E.T.,Monthly E.T.,Annual E.T.
2011-09-06 22:00:00,Light Clouds,64.3,50.6,64.3,29.293,1.0,48,0.00,0.00,61,44.0,80.6,11.0,0,0.0,0,0,0,0,0,0.0,0.0,32.0,32.0,32.0,0.00,0.00,0.00,0.00,0.00,
So the date time should work as "one field" and then
Y-m-d H:i:s