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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |