Import από .ods σε phpmyadmin version 3.3 +

It seems that Open Office automatically compresses the file in a format not compatible with phpmyadmin.

What you have to do is:

1. Save the file as ods.
2. After you have closed the file from the Open Office Calc, rename it from .ods to .zip.
3. Open the zip file and uncompress (export) the content.xml
4. Rename it from .xml to .ods
5. Compress it to .gz with 7zip application. It is free and you can get it from:
6. Make sure the file is named as content.ods.gz
7. Import the file with phpmyadmin. Most of the times you have to choose utf8 encoding but that really depends on your database tables format.