Import Export Wizard for SQL Server 2016

Question

Import Export Wizard for SQL Server 2016

Dom 881

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

OR

What specific install or configuration package from SS 2016 do I need to run to ADD this component to my existing installation?

Thanks.

Accepted answer

1 additional answer

Your answer

Answer 1

Erland Sommarskog 120.1K MVP

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?

Dom 881 Reputation points

2023-03-13T15:58:00.5433333+00:00

Although I did not find this file under the path you provided (I have the path, which I assume is for SS 2016 but there is no DTS folder under it), I recalled that the IT department installed SS 2019 Express on this machine for another purpose (even though 2016 is our production DB). I did find DTSWizard.exe under that path (replacing 130 with 150 from your example above). I made a shortcut to that .exe and the Wizard works great for Import/Export between SS 2016 and Excel 2016 (64-bit). Thans for getting me in the right direction! Not sure why this doesn't show up with my 2016 install. In fact, there is no "SQL Server 2016" group in the Start menu at all!

Answer 2

Hi @Dom,

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.

Share via

Import Export Wizard for SQL Server 2016

1 additional answer

Your answer