擅长:python、mysql、java
<p><strong>可以。</strong>只需安装</p>
<pre><code>AccessDatabaseEngine_X64.exe /passive
</code></pre>
<p>(其中包含x86和x64版本的驱动程序)您就可以了。不要忘记<code>/passive</code>选项,因为如果您这样做,除非您也安装了MS Office 2010,否则不会安装它。您可以从<a href="https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255" rel="nofollow noreferrer">Microsoft Access Database Engine 2010 Redistributable site</a>下载该文件</p>
<p>安装后,在python shell上运行以下命令,以测试一切正常:</p>
<pre><code>import pyodbc
[x for x in pyodbc.drivers() if x.startswith('Microsoft')]
</code></pre>
<p>你应该打印出来</p>
<pre><code>['Microsoft Access Driver (*.mdb, *.accdb)', 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)', 'Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)', 'Microsoft Access Text Driver (*.txt, *.csv)']
</code></pre>