SQL Server数据导入工具中缺少Microsoft Excel作为选项 [英] Missing Microsoft Excel as option in SQL Server data import tool

问题描述

我正在64位Windows Server 2012 R2上运行SQL Server2012。

我没有安装MS Office。

我现在注意到，当我开始Start- >程序文件-> Microsoft SQL Server 2012->导入和导出数据（64位），数据源下拉列表中缺少MS Excel文件选项。如何获得该选项而无需在服务器上安装Excel或Office？

I'm running SQL Server 2012 on a 64bit Windows Server 2012 R2.
I don't have MS Office installed.
I now notice that when I start Start->Program Files->Microsoft SQL Server 2012->Import and Export Data (64-bit) the MS Excel file option is missing from the datasource dropdown. How can I get that option without having to install Excel or Office on my server?

推荐答案

必须安装此驱动程序： https://www.microsoft.com/en-us/download/confirmation .aspx？id = 13255

Had to install this driver: https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

在此之后它可以工作了：）

After that it works :)

这篇关于SQL Server数据导入工具中缺少Microsoft Excel作为选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！