Le 07/07/13 21:37, Mark LaPierre a écrit :
Any suggestions on how to proceed from here? Do I just copy and paste
the data from the spreadsheet directly into the mySQL table?
You could try this :
1) Open your ODB file, click on the Tables icon so that you can see the
list of tables in your mysqldb.
2) Now open your Calc spreaadsheet.
3) In the top left hand corner of your spreadsheet, click on the on the
grey corner square/rectangle so that the whole sheet gets selected.
4) Now drag and drop the whole sheet to the space where your mysql table
list is visible within the ODB container and the copy data assistant
should start up. Bear in mind that the assistant doesn't always
recognize and set field types correctly when converting from Calc to
Base, so you will have to check this before validating the creation of
the table, otherwise you may end up with truncated data in your table or
some funky odd stuff. The most problematic ones seem to be date/datetime
strings. If you have images pasted in your spreadsheet cells as part of
your data set, these will not be converted to binary large objects by
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy