

THIS SOFTWARE IS PROVIDED AS IS, AND M.I.T.
#ACTUAL TECHNOLOGIES ODBC MANAGER HOW TO#
As far as you know, there are no freely available ODBC connectors for Mac and Excel for Mac? (Yes/No).Īgain, thanks for your response and for your leads. How to Obtain Actual Technologies ODBC drivers allows Mac OS X users connect to enterprise databases using common desktop applications such as Microsoft Excel and FileMaker Pro. Copyright 1992-2004 by the Massachusetts Institute of Technology. using the unicode driver hangs up Filemaker as soon as I try to link to the database to import a table. But I need a more extensive character set. I need an ODBC that is specific to Mac and Excel for Mac? (Yes/No)Ģ. Connecting using the MySQL ODBC 5.3 ANSI driver version (32 bit) works fine. In the ODBC Administrator window, go to the System DSN tab, and click the Add button. Click on the Padlock icon and enter your MacOS administrator account username and password. So, the questions I would like confirmation with are:ġ. Launch ODBC Manager (called 'ODBC Administrator' in earlier versions). Visting the Actual Technologies site, I DID find what appears to be support for ODBC drivers for Excel on Mac OS X, but I must purchase a license: Visiting OpenLink Software's site, I could not find any suitable ODBC drivers for Excel on Mac OS X: See FileMaker ODBC and JDBC Guide and Claris Pro and FileMaker Pro Help. macOS: ODBC Manager, a freeware product from Actual Technologies. Therefore, I need to find an ODBC connector for Mac OS X for Excel (on a Mac). ODBC and JDBC features: FileMaker ODBC and JDBC drivers (FileMaker Pro only), which are available in the xDBC folder in the installation disk image and at Updates and release notes.

Secondly, I am no computer expert, but my understanding of an ODBC connector is that it is specific to not only platform (e.g. However, before I jump to conclusions, I'd like to share my understanding with you in the event that I am missing something.įirst, I must connect to an Excel spreadsheet and not another data source. I investigated the options you provided to me, but it doesn't look like they will work.
