Share via

Mac系统下的excel使用外部数据的问题

经理 王 0 Reputation points
2023-04-06T06:19:22.59+00:00

1.mac excel引入外部数据定义字符串.jpg 1.win10 excel引入外部数据定义字符串.png 1.将win10创建的excel表复制到mac里系统的时候刷新数据报错.jpg 以上均为引入外部数据选择sql server 以下均为在MAC EXCEl 插入数据透视选择外部数据报错 2.excel 数据透视表问题.pdf

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2023-04-06T07:33:34.35+00:00

    你好，

    请问你是如何创建链接的？

    你在Windows创建的链接是使用的32位ODBC驱动程序吗？如果是使用的32位，建议改成64位的再建立链接。

    你也可以尝试根据该文章下载对应的ODBC驱动来测试下是否可以帮助你解决问题。

    https://support.microsoft.com/zh-cn/office/%E4%B8%8E-excel-for-mac-%E5%85%BC%E5%AE%B9%E7%9A%84-odbc-%E9%A9%B1%E5%8A%A8%E7%A8%8B%E5%BA%8F-9fa6bc7f-d19e-4f7f-9be4-92e85c77d712

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.