Share via

SQL Server Standalone Import Export Wizard

Dom 856 Reputation points
2024-11-03T13:56:27.0766667+00:00

I need to import data from Excel 64-bit (2016/O365) into a table in SQL Server 2016, The built-in Import/Export wizard in SSMS has never worked for this purpose (it is a 32-bit app and always fails). To get around this, I had been using a standalone version of this Import/Export wizard that I launched directly from the start menu (not from within SSMS). That always worked fine.

However, I just got a new PC. I cannot seem to find how to obtain the standalone version of the wizard that will import from Excel 64-bit. Could you please direct me how to download and install this tool. Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,159 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 29,191 Reputation points
    2024-11-04T01:46:46.16+00:00

    Hi @Dom

    You can install the SQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). For more info, see Download SQL Server Data Tools (SSDT).

    User's image

    Besides, check this similar thread: SQL Import Wizard 64-bit.

    Best regards,

    Cosmog

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments
  2. Olaf Helper 45,366 Reputation points
    2024-11-04T06:52:35.81+00:00

    I need to import data from Excel 64-bit

    An Excel file has no 32/ 64-bitness, it's just a file and therefore it doesn't matter which of 32/ 64-bit version of the Import/Export wizard you use.

    Do you get an error message and if, which one exactly?

    0 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.