Re: problem loading dates from txt file

2005-05-31 Thread Jeff Mao
If the data is on a spreadsheet, then why not use excel to rewrite the date? For example, copy the text where the dates are,...then format the entire column to be "text" and not a date (because excel stores dates as numbers,...but displays them as dates),...then paste the dates back into

Re: problem loading dates from txt file

2005-05-31 Thread Frank Bax
At 05:23 AM 5/31/05, James M. Gonzalez wrote: Im loading rows from a txt tab separated fields file into a MySQL table. It mostly works, but the date format in one field is not the type that MySQL likes. So right now Im loading it as a char field. Yes, it is ugly and a pain to work with. I would l