[libreoffice-users] How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?
Hi. I'm on a Mac and trying to replicate a process I'm very familiar with on Windows using MS Excel. I have a database (a MySQL database) and I want to create a spreadsheet that will allow users to quickly query the database and get reports/counts/etc. In Windows, I create views on the database and use MS Query / ODBC to link between Excel and the database. All works exactly as you'd expect. No drama, hassle or anything. I'm no longer working in a Windows environment and I'm struggling with what seems to be a fairly obvious use case. I've been recommend LibreOffice, and for the bits and pieces I've used so far, I'm impressed. I've managed to create a database link and I can create views and store them and, on the surface, it looks OK. When I look at the spreadsheet, I can see no way to link to the database. When I open the Navigator, I can see Database Ranges - but that's not what it seems. Now, I know I can cut'n'paste the data. This is NOT what I want. The use case is it allow a user to open the spreadsheet and either automatically or manually update the data from the database. No complex cut'n'paste or 20 click madness. Any real help would be greatly appreciated. Thanks in advance. Regards, Richard. -- Richard Quadling Twitter : EE : Zend : Fantasy Shopper @RQuadling : http://e-e.com/M_248814.html : http://bit.ly/9O8vFY : http://fan.sh/106/5tw -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?
Hi :) Hopefully other people will have better answers later but it might be worth having a quick flick through likely chapters in the official documentation on http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Good luck and regards from Tom :) --- On Mon, 30/4/12, Richard Quadling rquadl...@gmail.com wrote: From: Richard Quadling rquadl...@gmail.com Subject: [libreoffice-users] How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet? To: users@global.libreoffice.org Date: Monday, 30 April, 2012, 19:25 Hi. I'm on a Mac and trying to replicate a process I'm very familiar with on Windows using MS Excel. I have a database (a MySQL database) and I want to create a spreadsheet that will allow users to quickly query the database and get reports/counts/etc. In Windows, I create views on the database and use MS Query / ODBC to link between Excel and the database. All works exactly as you'd expect. No drama, hassle or anything. I'm no longer working in a Windows environment and I'm struggling with what seems to be a fairly obvious use case. I've been recommend LibreOffice, and for the bits and pieces I've used so far, I'm impressed. I've managed to create a database link and I can create views and store them and, on the surface, it looks OK. When I look at the spreadsheet, I can see no way to link to the database. When I open the Navigator, I can see Database Ranges - but that's not what it seems. Now, I know I can cut'n'paste the data. This is NOT what I want. The use case is it allow a user to open the spreadsheet and either automatically or manually update the data from the database. No complex cut'n'paste or 20 click madness. Any real help would be greatly appreciated. Thanks in advance. Regards, Richard. -- Richard Quadling Twitter : EE : Zend : Fantasy Shopper @RQuadling : http://e-e.com/M_248814.html : http://bit.ly/9O8vFY : http://fan.sh/106/5tw -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] How do I link data from a LibreOffice Database (linked to a MySQL Server) to a LibreOffice Spreadsheet?
Hi, On Monday 30 April 2012, 19:25:38 Richard Quadling wrote: Any real help would be greatly appreciated. Did you have a look at http://user.services.openoffice.org/en/forum/viewtopic.php?f=75t=18511 ? Regards, Nino -- For unsubscribe instructions e-mail to: users+h...@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