How to use mySQL import from openoffice

Asked By Willie Stout 0 points N/A Posted 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.

Thank you

• Status: Open
• Question Views: 872
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By WilsonJames 0 points N/A #138738

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.

About WilsonJames

Questions
3

Answers
99

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 12/14/2012
• Question Category: Misc Databases