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 Other
0 comments No comments
{count} votes

Accepted answer
  1. Jeffrey Williams 1,896 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 14,006 Reputation points Microsoft External Staff
    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 47,436 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.