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. HTH, Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
