How do I connect to MySQL? or OOo base?
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.