Error importing excel file into SSMS

Legrand 20 Reputation points
2023-08-10T17:28:59.1533333+00:00

using SSMS 18.0, SQL SERVER 2022 and i am getting the error below. having windows 10 and visual studio 2015. i have installed ODBC 16, quietly already before it now went to this error. please need help urgently for my assignment.

SQL error

SQL Server Other
0 comments No comments
{count} votes

Accepted answer
  1. Javier Villegas 900 Reputation points MVP
    2023-08-10T17:47:20.4466667+00:00

    Hello

    you may want to try running the 32 bits version of Import/Export Wizard from SQL SSMS

    Connect to an Excel Data Source (SQL Server Import and Export Wizard)

    My preference is to export the excel file to CSV and import it directly from SSMS


0 additional answers

Sort by: Most helpful

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.