N/APosted on - 12/13/2012
I have some data from my spreadsheet using the Open office that needs to be move or imported to Mysql. Now I need a step by step in using mysql import from openoffice because I've got some issues with the move, like the dates are not aligned or some part missing. I would greatly appreciate your help on this matter.
How to use mySQL import from openoffice
Try using the MySQL 5.0, JDBC and ODBC driver and migration kit. They transfer all your files to your specified location at ease. You just have to wait for them to finish. Although, some users claim that they were also having problems with the date alignment.
If that is the case, all you can do is to make a new table. Make your dates a text data type. Make new fields in the MYSQL and use MYSQL function to date conversion.