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


Le 09/07/13 06:46, Mark LaPierre a écrit :

Hi Mark,


I get a new spreadsheet every week with some duplication of data on each
sheet from what was on the previous sheet.  I don't want to copy and
paste the duplicate data into the main table.  I'll have to think about
this one for a while.

You can't currently use LO to import text/spreadsheet data as a basis
for table creation with the mysql driver (any of them, whether direct,
odbc or jdbc). I don't actually know of any opensource program that does
this for mysql, all of the solutions I've seen so far, which do not use
LO, use some kind of scripting language, e.g. PHP, to import CSV, Excel,
text files (e.g. xml), or direct SQL inserts. For example, PHPMyAdmin
has such a feature (but this is version/build dependent)


Another possibility is to use the HSQLDB functionality of linking
directly to text tables. You would have to have your data as CSV in that
particular case. Of course, this would mean using the HSQLDB as an
intermediary database from which you would then copy the data into your
mysqldb, so it doesn't really solve the problem of simplifying the whole
process. Look up the HSQLDB documentation to find out how this works.


Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@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

Context


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.