Jump to content

Archived

This topic is now archived and is closed to further replies.

HawkCode

CSV Import Driving me crazy!!!

Recommended Posts

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

Share this post


Link to post
Share on other sites

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].

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Thanks,

 

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

 

 

Rich

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.