how to export data from access to mysql

tiger_cs

i have table in access now i want to export the data to mysql but i dont know how..
i use the :
LOAD DATA LOCAL INFILE "C:\mysql\data\database_name\file_name.txt" into table table_name; Press button GO.

There is a bug though 🙁((( All dates are entered as 0's.
but i dont know some one have another wat to do it....

thank you ,,

daynah

I've done this before. Well, when you export, it is saved to a text file right? Just "Replace All" of the 00-00-0000 with nothing. That should get rid of the zeros in the date. 🙂

tiger_cs

I've done this before. Well, when you export, it is saved to a text
file right? Just "Replace All" of the 00-00-0000 with nothing. That
should get rid of the zeros in the date. 🙂
..
you say i open the text file ,
then "Replace All" time with 00-00-0000,
or what , i dont get your point..

hope to hear you soon, Daynah..

thank you ,,

tiger_cs

hello DAynah,,
can you show me step by step
how to export the data from access table to
my sql table.
i did it work but when i query in mysql then the field of "Time" in mysql is NULL.
but i dont know how ,,
so can you help me to show me step by step..
or any one else can help em,,

thank all..

Anon

Hi:

There is a good article at devshed.com titled
MySQL and ODBC that may help

Anon

MYSQl has another format for date:
0000-00-00

That is year month and then day. Make sure u use date as format in MYSQL. I see this answer is way too late but maybe it helps someone looking for the same solution ...