求助：64位OS搭配32位MS Office时SQL Server 2014 Import Export Wizard无法操作Excel

I totally get this frustration—mixing 64-bit SQL Server with 32-bit Office creates a driver mismatch that blocks the Excel option from showing up in the 64-bit Import/Export Wizard. Here's exactly how to resolve this, including targeted troubleshooting since you mentioned you’ve already tried basic steps:

Root Cause #

The 64-bit wizard relies on 64-bit OLE DB drivers for Excel, but your 32-bit Office installation only includes 32-bit drivers. These architectures can’t communicate, so the Excel option is hidden by default. The fix is to use the 32-bit version of the Import/Export Wizard instead.

Step-by-Step to Launch the 32-bit Wizard #

Option 1: From the Start Menu #

• Open your Start Menu and navigate to Microsoft SQL Server 2014 > Look for an entry labeled Import and Export Data (32-bit). Click this to launch the correct wizard.
• Note: If this entry is missing, the 32-bit components weren’t installed during SQL Server setup (this is common for default installs).

Option 2: Directly Run the Executable #

If the Start Menu entry is nowhere to be found, you can launch the 32-bit wizard directly from its file path:

• Open File Explorer and navigate to:

  C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\DTSWizard.exe
  

• Double-click DTSWizard.exe to start the wizard. You should now see Excel as an option for source/destination.

Option 3: Create a Shortcut (For Quick Access) #

Right-click DTSWizard.exe from the path above, select Create shortcut, and move it to your desktop or Start Menu for easy access later.

Troubleshooting If You Still Have Issues #

If you’ve tried the above and Excel still doesn’t appear:

• Verify 32-bit Integration Services are installed:
  1. Open SQL Server Installation Center.
  2. Go to Maintenance > Modify.
  3. Under Shared Features, ensure Integration Services is checked. Expand it and confirm the 32-bit tools are included (they should be if you select the feature).
  4. Complete the modification to install any missing components.
• Fix Driver Conflicts:
  If you previously installed the 64-bit Microsoft Access Database Engine to try resolving this, it will conflict with your 32-bit Office. Uninstall the 64-bit version from Control Panel > Programs and Features—your 32-bit Office already includes the necessary drivers.

Once you launch the 32-bit wizard, you should be able to import/export data to Excel without any issues.

内容的提问来源于stack exchange，提问作者Kathy S