CSV Import Driving me crazy!!!

[HawkCode]

Hi,

 

I'm trying to import a CSV from an Access query and keep getting the error:

 

[Err] 1292 - Incorrect datetime value: '' for column 'DateEntered' at row 1

 

here is a sample of the data:

 

[!--fonto:Courier New--][span style=\"font-family:Courier New\"][!--/fonto--]1,"Mr.","Donald","F.","Dickerson",

"P.E., CIPE","Estimator",,1/23/1997,"Import"

DATE ENTERED IS--------^^^^^^

[!--fontc--][/span][!--/fontc--]

I've tried it delimited with "," TABs all same result. Anybody got any ideas.

 

TIA

 

Rich

[effigy]

it should probably be quoted and conform to the formats discussed [a href=\"http://dev.mysql.com/doc/refman/4.1/en/datetime.html\" target=\"_blank\"]here[/a].

[fenway]

If you're just doing it once (or infrequently), the best way to do this is to "cheat' -- first, import the access dates into new CHAR field. Then, set the desired date column using the STR_TO_DATE() function, and drop the temporary CHAR column.

 

UPDATE table1 SET date_field=STR_TO_DATE(temp_date_field, '%m/%d/%Y');

 

Hope that helps.

[HawkCode]

Thanks,

 

I ended up writing my 1st php script to do it... I'vmade the summit and the rest is down hill!

 

 

Rich