Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Le 07/07/13 21:37, Mark LaPierre a écrit :

Hi Mark,

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
the assistant.



To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.