Linux - DesktopThis forum is for the discussion of all Linux Software used in a desktop context.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
I have a MySQL database that I populated with data from a spread sheet. I was under the impression that I could connect to it from OpenOffice.org base. However base does not give me MySQL as a db option. It does allow a connection to MySQL using either odbc or jdbc, but I think this means I have to write my own application and I'm not at all sure I can do that, at least not as quickly as I need the data.
Can I in fact open MySQL databases in OOo base? If so, how?
If not, can anyone suggest a gui front end I can use? All I really need to do is update the data and create views for mailing lists.
Failing that, I can always create the views from the command line using sql, but how in the heck can I use the views with OOo mail merge?
I've tried to google for an application, but all I come up with are Windows applications and I don't have windows installed on my machine.
I was able to convert the original spread sheet to an OOo database, but it only lets me read it, I can't manipulate it. Thats why I went the MySQL route. MySQL is really over kill for my needs, so if you can help me solve this problem I won't need a front end.
Any help with either problem gratefully accepted, I'm really in a bind here.
I have not used OpenOffice.org to access a MySQL database, I usually use phpMyAdmin, as I installed Apache/PHP with MySQL on my system, and phpMyAdmin is the usual way of editing MySQL databases by hand, other then using the command line.