[libreoffice-users] Re: Base DB Connections

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