If you're having trouble installing or activating Office for Mac, you can find self-help troubleshooting steps for common issues. The MS Access JDBC driver from HXTT can be used with RazorSQL to read from and write to MS Access files on Mac OS X. More information on the HXTT In the JDBC URL field, enter something similar to the following. The following assumes an Access mdb file called fountainhead.mdb located.
With the Actual ODBC Driver for Access, you can connect to Microsoft Access databases and import data directly into an Excel spreadsheet or a FileMaker database. There is no need for an intermediary Windows PC - this driver reads data from the database file itself. The driver supports Access 97 or later, including Access 2003.
The Actual ODBC Driver for Access is the first commercial driver to connect to Access databases on a Mac without the need for complicated 'bridge' or 'router' solutions. A setup assistant, diagnostic utility, and on-line help are included with the easy-to-use installer.
The driver also lets you use a text file or Excel spreadsheet as a SQL database.
The driver supports standard SQL 'select' and 'join' statements to return data from multiple tables. The current version of the driver is read-only - 'insert' and 'update' SQL statements are not supported.
In addition to Access '.mdb' and '.accdb' files, the driver also works with tab delimited text files, '.csv' files and Excel '.xls' files.