Connect to SQL Server on Mac in Office 365 Excel

Anonymous
2020-02-01T03:55:47+00:00

On my Windows computer I can create a connection to my SQL Server and keep reusing it on any of my worksheets. On my Mac, every time I go to Data->New Database Query->SQL Server ODBC I have to enter in the server information. That is seriously inconvenient when I do so many different things with this data in different worksheets.

I have tried setting up a connection through Get External Data but it says there are no drivers on my computer.

Is this how Excel is supposed to work on my Mac or am I doing something wrong?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-03T09:23:18+00:00

    Hi Lindsay,

    May I know if you have some updated information? Feel free to post back if you need further assistance.

    Best Regards,

    Waqas Muhammad

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-02-01T09:57:58+00:00

    Hi Lindsay,

    Thanks for posting the query here in the community. I am very sympathetic to your experience. I do understand the inconvenience it has made and apologize for it.

    According to my test, if I import data from a database in Excel for Mac following the steps in this article, when I click "Data" tab> New Database Query> SQL Server ODBC, there will be a window called "Connect to SQL Server ODBC Data Source" pops up and ask me to type in Server name, Database, Authentication, User Name and Password.

    In addition, please try to create a new workbook to do the connection to see the result.

    If you can connect to it successfully in the new workbook, then please also try to open the workbook in your Windows computer to see if you can refresh the data.

    To better understand your situation, please help confirm some information:

    1. What is the Office version number? You can click Excel menu> About Microsoft Excel
    2. Could you please share with us detail regarding to “when I do so many different things with this data in different worksheets”. If necessary, please also capture some screenshots to clarify.

    3.Do you have the MySQL ODBC driver installed? Here is article for you reference. ODBC drivers that are compatible with Excel for Mac. If you installed ODBC driver, i find an article for you: Known Issues in this Version of the Driver.You can check the article to see if it can help you.

    Best Regards,

    Waqas Muhammad

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more