如何通过OLEDB或SSIS中的任何其他源连接Excel Source? [英] How to connect Excel Source via OLEDB or any other source in SSIS?

问题描述

除了"Excel连接管理器"之外，还有其他方法可以将Excel作为SSIS中的源进行连接.

Is there any other way rather than "Excel connection manager" to connect Excel as Source in SSIS.

我问这个问题是因为我在将Excel与"Excel Connection Manager"连接时遇到问题，因为在我的系统中安装了32位Excel，而Visual Studio版本是64位.

I am asking this question because I have an issue with connecting Excel with "Excel Connection Manager" because in my system Excel 32 bit is installed and the Visual Studio version is 64 bit.

我尝试将其与ODBC连接，但未成功.

I tried connecting it with ODBC but wasn't successful.

推荐答案

同时安装32位和64位AccessDatabaseEngine

如果需要与32位安装一起安装AccessDataBaseEngine x64，则需要以被动模式运行安装:

If you need to install AccessDataBaseEngine x64 alongside with 32-bit installation, you need to run the installation in passive mode:

被动模式安装步骤

1. 通过在开始"菜单下的Windows搜索框中键入cmd并选择cmd.exe来打开命令提示符
2. 键入64位Access Database Engine 2010安装文件的文件路径和文件名，后跟一个空格和/passive(这将运行安装而不显示任何错误消息).
3. 通过在开始"菜单下的Windows搜索框中键入regedit并选择regedit.exe
，打开注册表编辑器.

4. 在以下注册表项中删除或重命名mso.dll注册表值:

1. Open the Command Prompt by typing cmd in the Windows search box under the Start menu and selecting cmd.exe
2. Type the file path and file name of the 64-bit Access Database Engine 2010 install file, followed by a space and /passive (this runs the installation without showing any error messages).
3. Open the Registry Editor by typing regedit in the Windows search box under the Start menu and selecting regedit.exe

4. Delete or rename the mso.dll registry value in the following registry key:

"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths" 

更多详细信息和屏幕截图，请参见下面的链接

参考

• 查看全文