Microsoft Access

Microsoft has never been interested in creating a Macintosh equivalent of its flagship database program (which comes with the higher-priced versions of Microsoft Office for Windows). FileMaker, a much easier-to-use database program, towers over the Macintosh database market like the Jolly Green Giant (and has a decent following on the Windows side, too). Resistance, Microsoft apparently assumes, is futile.

It’s easy enough to get your data out of Microsoft Access; just choose File→Export. In the resulting dialog box, you can choose from a number of common export formats that can serve as intermediaries between the Windows and Mac worlds (see Figure 7-1).

Among them is Microsoft Excel—that is, you can turn your database into a spreadsheet. The beauty here is that FileMaker on the Macintosh can turn Excel documents into FileMaker databases without even batting an eye. You just drag the exported Excel document onto the FileMaker icon, and FileMaker does the rest.

Get Switching to the Mac: The Missing Manual, Yosemite Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.