Although there are bunch of tools that you can buy to do this tasks, they will charge you some money for the tools. If you are in a very tight budget or just want to try it. there is several step that you have to do.
1. Convert all column type in access table into type text. This is just to be save. if you have date field make sure the format of that field is the same as the format in Mysql. if you have table which is too large to convert, you can create new table with the same column count and all column type is text then do query 'insert into table_name_new select * from table_name_old'. It will move all content from old table to new table.
2. Export your table using the export tool from access. File - Export. select the type of file to CSV or text.
3. Create Mysql table and make sure the column count is the same as the column count from the original access table.
4. Once you have the comma seperated value you can use Mysql Command to load the data into the Mysql table, do this command in mysql
LOAD DATA LOCAL INFILE "/data/data_dump/clientT.csv" INTO TABLE MIS_Client FIELDS TERMINATED BY "," ENCLOSED BY "\"" LINES TERMINATED BY "\r\n";
read: load data in file fullpath/filename into table_name_in_mysql with the field in one line terminated by comma and text field enclosed by double quote and the line terminated by \r\n character. if this is linux text file ussually using \n is enough. Windows end of line character is \r\n.
and lets mysql do its magic....
Thats it. Any question you can shoot to this blog.
