At 16:17 -0600 5/7/03, Mike Hillyer wrote:
>Also, just reformat the date in Access before you export.
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
>From: Charles Kline [mailto:ckline@stripped]
>Sent: Wednesday, May 07, 2003 2:03 PM
>Subject: moving data from access to mysql
>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