For what it's worth, on my machine the 64-version of the wizard is in "C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTSWizard.exe". I don't really know how it got installed there, but I always install Integration Services, even if I don't know SSIS. Maybe the wizard comes with SSIS?
Import Export Wizard for SQL Server 2016
I started a new job and my company is running SQL Server 2016. So far, I have been unable to successfully import data from Excel using the Import/Export wizard in SSMS. Google searches point to the issue being that the wizard in SSMS is 32 bit and we are running 64 bit Excel. The suggestion is to use the standalone 64 bit version of the wizard outside of SSMS. However, no where in my Start menu (Win 10) do I see any reference to this tool (it is not under any of the SQL Server items in the Start menu). I am running SQL Server 2019 and 2022 on several of my home and development machines and they all have this tool in the start menu. How can I
- Download the standalone 64-bit tool for SS 2016
- What specific install or configuration package from SS 2016 do I need to run to ADD this component to my existing installation?
Sign in to comment
1 additional answer
Sort by: Most helpful
This issue is due to the PC doesn't have Excel read drivers. Please download and install the 32bit version.
Microsoft Access Database Engine 2010 Redistributable
If you need both the 32-bit and the 64-bit adapters, please refer to this article.
To use the 64-bit version of the SQL Server Import and Export Wizard, you have to install SQL Server. SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) are 32-bit applications and only install 32-bit files, including the 32-bit version of the wizard.
You may start the SQL Server Import and Export Wizard from the command prompt:
Start the SQL Server Import and Export Wizard
If the answer is helpful, please click "Accept Answer" and upvote it.