Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How I can import with keeping the structure of the data like date fields and numiric fields the rest of the fields is text. With import into mysql with import function from phpmyadmin from an .ods spreadsheet all is converted to text fields.

share|improve this question
Can you not export the ods file to a CSV format and then import it into PHPmyadmin? –  StanleyJohns May 17 '13 at 20:19
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.