(Note: If you're using Leopard, clicking on the ODBC keywords and values can be a little difficult to edit them.
Odbc for mac excel mac os#
Odbc for mac excel for mac os#
Select the driver, in my case FilemakerProUser and click OK. Actual ODBC Driver for OpenBase for Mac OS v.2.2 Now you can access data from your OpenBase database using Microsoft Excel and FileMaker Pro.
Click on the System DSN tab, and click the "Add" button.ġ1. I clicked "Add a driver", and entered the following information:ĭriver file name: /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk20.dylib I launched iODBC Administrator and selected the tab "ODBC Drivers".Ĩ. I turned on ODBC Sharing, selected "Test.fp7" in the lower left, and set ODBC/JDBC access to "All Users", and clicked "OK".ħ.
I pulled down the File menu and selected "Sharing -> ODBC/JDBC."Ħ.
Odbc for mac excel pro#
I launched FileMaker Pro 10, created a new database file "Test.fp7" with one field (Name) and one record (TSGal)ĥ.
I put in my FileMaker Pro 10 disc, opened the xDBC directory and copied the SequeLink.bundle into the Hard Drive -> Library -> ODBC (folder)Ĥ. I installed it, and it was placed inside my Hard Drive -> Applications -> iODBC (folder)ģ. I downloaded the iODBC Administrator at:Ģ.