| View previous topic :: View next topic |
| Author |
Message |
mobilefrenzy
Newbie
Joined: 31 Oct 2006
Posts: 1
|
 Posted: Tue Oct 31, 2006 3:11 am Post subject: Export to MYSQL |
 |
|
I have a .xls file which I open in OO Calc. Is it possible for me to export the data from this file to MYSQL?
In the File -> Export, the options I get are only export to either pdf or XHTML formats.
Any help willl be highly appreciated
_________________
http://www.explore-mobiles.com |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Tue Oct 31, 2006 3:40 am Post subject: |
|
|
A mysql-db is not a single file. It supports more than a dozend different datatypes per field, whereas a spreadsheet has only two types (string and floating point number) and you may mix both types in one column as you like.
You need to double-check the integrity of all sheet-columns. Don't mix numbers and strings, eliminate all errors.
Save your sheet as csv and import into mysql. Mysql has a pretty tool for this.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
