SQL Import Wizard 64-bit

Justin Schroeder 26 Reputation points
2021-03-03T18:11:41.213+00:00

Hello,

Is there a standalone version of the 64-bit import wizard available? I just updated Excel from 32 to 64 bit and can no longer use the wizard in the 32 bit SSMS. My understanding is that the 64 bit is available with SQL server, but have no use for anything outside of the wizard.

Thanks!

  • Justin
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,046 questions
0 comments No comments
{count} votes

Accepted answer
  1. Jeffrey Williams 1,891 Reputation points
    2021-03-03T22:04:18.693+00:00

    You can download the 32-bit ACE driver and install that...to get it installed you need to use the /quiet or /passive parameter from the command line. That will give you both drivers and the import/export wizard will work.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-03-04T02:19:08.957+00:00

    Hi @Justin Schroeder ,
    You can search SQL Server Import and Export Wizard 64-bit in the search bar next to the start menu.
    74005-01.jpg

    Or you can find it under the Microsoft SQL Server 20xx folder in the Start menu.
    73860-02.jpg

    For more ways to start the 64-bit wizard, please refer to this article.

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Olaf Helper 42,451 Reputation points
    2021-03-04T07:29:56.44+00:00

    Is there a standalone version of the 64-bit import wizard available?

    No, the 32 bit wizard comes with SSMS, the 64 bit wizard only with full installation of SQL Server.

    0 comments No comments