At 16:17 -0600 5/7/03, Mike Hillyer wrote:
>Also, just reformat the date in Access before you export.
>
>Mike
Reformat it to what, though? The thing I don't get about the
request below is that, if all you've got it a month name,
how are you supposed to fill in the other parts of the timestamp
value?
>
>-----Original Message-----
>From: Charles Kline [mailto:ckline@stripped]
>Sent: Wednesday, May 07, 2003 2:03 PM
>To: mysql@stripped
>Subject: moving data from access to mysql
>
>
>hi all,
>
>i have to move some data from an access table to a mysql table.
>everything looks pretty straight forward, except the date type fields.
>in access they are stored just as a month name, but in the new mysql
>table we are using a unix timestamp. is there any good way of handling
>this?
>
>thanks
>charles
