Nowadays, just because you have a Mac doesn't mean that you can't use the Microsoft Access database. The developers of Actual ODBC Driver for Microsoft Access claim that it is the first commercial driver to connect to Access databases on a Mac without the need for complicated "bridge" or "router" solutions.
Actual ODBC Driver for Microsoft Access allows you to connect to the Microsoft Access database and import data directly into an Excel spreadsheet or FileMaker database. The beauty of this is that it cuts out any need for a Windows PC in the middle - the ODBC driver reads data from the database directly. The idea is that using FileMaker or Excel, you can still quickly create pivot tables and charts and graphs from data in your Access database.
When you install it, you're presented with a setup wizard to help you with setting up a connection. This is not for the faint hearted, however unless you're only specifying a simple connection, in which case you only need to specify the location of your database file. Anything more advanced will probably require help from your network administrator assuming you're trying to access a company database because it requires you to configure such things as the User DSN, System DSN, Drivers and Connection Pooling. There is however a fairly short but well explained help section if you have to do it on your own. Finally, there is a diagnostic tool to check if everything is setup correctly when you've finished.
If you need to use a Microsoft Access database from your Mac now you can with Actual ODBC Driver for Microsoft Access.
