Import Export Wizard for SQL Server 2016

Dom 751 Reputation points
2023-03-11T18:54:53.42+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,757 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
0 comments
Accepted answer
  1. Erland Sommarskog 101.4K Reputation points MVP
    2023-03-11T19:20:54.3266667+00:00

    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?

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2023-03-13T06:16:56.96+00:00

    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.

    You may start the SQL Server Import and Export Wizard from the command prompt:

    Start the SQL Server Import and Export Wizard

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments