Using Microsoft Office for Mac as a Relational Database

By Jim Gordon, co-author of Office 2011 for Mac All-in-One For Dummies.

Part 2 - Setup


Choosing an ODBC Driver

I recommend choosing a driver based on the location of the data source file you wish to use. As of this writing there are two companies making  ODBC drivers for Macintosh. Both companies offer superlative customer support and are Mac-friendly.

ODBC drivers from these two companies take different approaches to querying data. If you have the luxury of being able to choose a local, shared, or network location for your data source, you may wish to try both drivers to see which works faster with your particular data sources, queries, network speed and server configuration.

Installing an ODBC Driver

OpenLink and Actual Technologies provide clear and easy to follow instructions for installation and setup of their drivers. Be sure to read and follow their instructions and you should have little trouble installing the drivers. The drivers are available in free modes so you can test before buying.

Part 1
Part 3 (Next)