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: [email protected] 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
