本文介绍了Excel 2016和PostgreSQL的ODBC驱动程序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试通过ODBC连接将Excel 2016 for Mac(OS X El Capitan,10.11)连接到PostgreSQL数据库;所以我下载了驱动程序,特别是。

I am trying to connect Excel 2016 for Mac (on OS X El Capitan, 10.11) to a PostgreSQL database through ODBC connection; so I downloaded the drivers, specifically Actual Open source Databases.

我设置了所有的东西,测试连接成功,但一旦我尝试保存设置,Excel崩溃。

I set everything up, test the connection successfully, but as soon as I try to save the settings, Excel crashes.

我应该尝试重新安装Excel?任何意见强烈赞赏!

Should I try to re-install Excel? Any advice is strongly appreciated!

(我已经知道,Excel吸吮...但我仍然需要建立连接)
Best,Vincenzo

(I know already, Excel sucks ... but I still need to establish the connection)Best, Vincenzo

推荐答案

Excel 2016有问题(2015年10月份更多,但仍在2016年11月份出现)。真的没有准备好黄金时段。 Excel 2011是一个更好的赌注,因为这样。

Excel 2016 has issues (much more substantial in October 2015, but still present in November 2016). It's really not ready for prime time. Excel 2011 is a better bet, as things stand.

如果你坚持使用Excel 2016,请更新到最新的(截至2016年7月的3.52.12),创建您的DSN(系统DSN建议;用户DSN可能适用于您) iODBC Administrator.app (在$ code> / Applications / iODBC / ),然后使用它与Excel。

If you're stuck with Excel 2016, update to the latest iODBC (3.52.12, as of July 2016), create your DSN (System DSN recommended; User DSN may work for you) in iODBC Administrator.app (found in /Applications/iODBC/), and then use it with Excel.

(,由生成,是开源ODBC驱动程序经理苹果自10.2以来已经捆绑到OS X中,但苹果仍然比现在的iODBC版本多了几年。)

(iODBC, produced by my employer, OpenLink Software, is the open source ODBC driver manager Apple has bundled into OS X since 10.2, but Apple remains several years behind the current iODBC version.)

这篇关于Excel 2016和PostgreSQL的ODBC驱动程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-31 22:11