Migrate reports from MS Access to OOo Base

Posted by John Gardeniers on Server Fault See other posts from Server Fault or by John Gardeniers
Published on 2010-06-09T02:55:00Z Indexed on 2010/06/09 3:02 UTC
Read the original article Hit count: 365

I'm currently looking at upgrading our office machines from Office XP to Office 2010. For most users the standard edition is fine but just a few of us use Access. There are only a couple of standalone Access databases but the program is used fairly extensively (mostly by myself) as a front end to MySQL.

As the cost different between standard and pro versions of Office 2010 is about $170 (AUD) I'm looking at possible alternatives to Access. I'm no huge fan of Open Office but could be convinced to use it if I can find a way to migrate the many reports we currently have in Access. The data is not a problem. So far I've found nothing to suggest this is even possible/practical but perhaps someone here knows otherwise.

I'm also open to suggestions for other alternatives to Access but it must be able to produce flexible reports easily. That is the one real strength of Access in my view.

Because of its subjective nature I'm making this community wiki.

© Server Fault or respective owner

Related posts about reporting-services

Related posts about ms-office