How did I figure this out? It happened after having wasted tons of time, growing increasingly frustrated and feeling totally stuck with the following error message:
#SEQUEL PRO SQL INSERT EXPORT HOW TO#
Therefore, Excel doesn't know how to fetch the config file in the right place. Why? Because the driver gets downloaded to /usr/local but Excel Microsoft Office is a sandboxed application, so it doesn't have access to /usr/local. To make it work, you need to move the SQL driver folder from /usr/local/ to /Library/ODBC/. Here might be the part where you struggled if you tried it by yourself. Click here for the official PostgreSQL ODBC Driver. You can download here the Microsoft ODBC Driver for SQL Server. For instance, I’m using MySQL so I installed the MySQL driver for Mac. You have to install a driver for your SQL database. ODBC Manager was developed as a replacement for ODBC Administrator. Mac OS used to include an ODBC Administrator utility but Apple stopped including the ODBC Administrator with Mac OS starting with the release of Mac OS X "Snow Leopard". ODBC Manager is a Mac OS utility application that configures ODBC data sources such as Microsoft Excel. In order to do so on Mac, you need to install an interface to manage ODBC configuration files.
You need an ODBC (Open DataBase Connector) to load data from a SQL database to Excel. If you want to learn how to connect Excel to your SQL database with a Mac in order to query data from your SQL database into Excel, read the following lines. The good news is: I have the solution to your problem! I’ve been through it too… only to realize that there is kind of a bug on Excel for Mac 🤦♀️ (to be precise, I work on Microsoft Excel for Mac version 16.33).
If you work on a Mac and you experienced difficulties connecting your SQL database, I’d like to tell you that I share your pain. Connect Excel to an external data source: your SQL database
0 kommentar(er)
