Quote:
|
Originally Posted by gphillipk If you have MS Office for Mac, couldn't you use Excel to read the data out of the Access db? Unless Excel for Mac is radically different, you ought to be able to design queries in Excel to extract data and save data back into the Access db, without having to convert. But if you need more advanced (relational-db) functionality, I s'pose you ought to convert. |
Excel for Mac isn't radically different, but everything around it is. To run a query from Excel to an Access database, you need something to answer to the query. In this case that would be Access (via ODBC) or some built-in support for Access databases in the operating system (as you get in Windows). Since you don't have either on the Mac, there isn't anything around to respond to the queries.
I've been searching for something similar for years, but I always end up biting the bullet. Just find some poor sod with Windows and Access, and ask him or her to convert your database to something you can use (CSV or SQL dump as suggested earlier).