Odbc for mac excel

broken image

The driver installation registers the driver with iODBC and creates a system DSN, which you can use in any tools or applications that support ODBC connectivity. You can find the latest version of iODBC on the iODBC site. On macOS, the CData ODBC Driver for Excel is preconfigured for use with the iODBC driver manager, as are many other products like Filemaker Pro, Microsoft Excel, and Tableau. These refer to your name and your machine's password. You'll be prompted for a name and password. To activate a trial, omit the input.Ĭd '/Applications/CData ODBC Driver for Excel/bin' In a terminal, run the following commands to license the driver.

broken image
broken image

The CData ODBC Driver for Excel driver requires macOS Sierra (10.12) or above. This section shows how to set up ODBC connectivity and configure DSNs on macOS.