How to use mySQL import from openoffice

Asked By 0 points N/A Posted on -
qa-featured

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.

Thank you

SHARE
Answered By 0 points N/A #138738

How to use mySQL import from openoffice

qa-featured

 

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.

Related Questions