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.