Q&A: how do I move data from Access onto my Mac?
Via the open question thread:
I'm about to buy a Macbook as my main computer. But I also use Access a lot, especially the mail-merge function (Word/Access). I've read your comments in MacRumors about the likelihood of Microsoft creating Access for Macintosh. What do you recommend instead?
It depends on what you're doing with Access. If mail merge is your most important task, then you can likely accomplish the same thing with Word and Excel. Excel 2008 can handle workbooks of up to 1 million rows and 16,000 columns (it's slightly bigger than 16k, but I can't remember the exact number since it's not a power of two). You could also move your address data into Entourage, and do a mail merge from there. For more information about how to do a mail merge in Word:Mac 2008, start with our help topic create a data source for a mail merge, which has links to creating form letters, mailing labels, and envelopes via mail merge.
For other database needs, depending on how big your databases are and what you're doing with them, you might find that either Bento or FileMaker will meet your needs. Bento is more for consumer needs, whereas FileMaker is good for business needs.
Alternately, you could use Boot Camp to dual-boot your Mac into Windows, or run a virtualisation application like VMWare so that you have access to Windows. Then you can run Access on your Mac for the times when you need it. This makes the most sense if you have a lot of big databases and you use Access frequently.