[libreoffice-users] Re: How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?

First you link a so called "Base document" to the database. Then you can 
link office documents.
File>New>Database...
[X] Connect to existing database
Type: MySQL
[X] Register the database
Specify the connection details.
Save the "Base document" (it is a configuration file actually).
You may add some useful SELECT queries for your purposes.

In Calc hit F4 and drag your table/query into the sheet.
This creates a linked import range (see Data>Define...).


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