Please help me, what should I do here? The option sql server native client is not appearing on screen when I try to import the excel file

Matta Sujeeth 0 Reputation points
2023-08-16T02:22:52.6433333+00:00

I downloaded the latest version Microsoft SQL server management studio 19.1 and in the video, the instructor used 19.0. I created a new database and I selected tasks->import data. Then SQL Server Import and Export Wizard opened and I selected datasource as Microsoft excel and clicked next. But in my destination, "SQL Server Native Client " is not appearing. What should I do? Please help me what should I do.

I can't upload the image but you can see the link here. I posted it on reddit, but sometimes you won't get an answer,so I asked here. If I am not clear with my question,I apologise ,you can see the image here. https://www.reddit.com/r/SQL/comments/15sc0re/please_help_me_what_should_i_do_here_the_option/?utm_source=share&utm_medium=web2x&context=3

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,066 questions
SQL Server | Other
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 122.3K Reputation points MVP Volunteer Moderator
    2023-08-16T21:39:00.2933333+00:00

    Select Microsoft OLE DB Driver for SQL Server. That's a more recent version than SQL Native Client. (The one listed on the bottom saying Provider instead on the other hand, is really old and dusty.)

    3 people found this answer helpful.
    0 comments No comments

  2. H VenkataSai Dumpala 0 Reputation points
    2024-08-16T20:01:07.9433333+00:00

    Please select Destination as Microsoft OLE DB Provider for SQL Server

    0 comments No comments

  3. H VenkataSai Dumpala 0 Reputation points
    2024-08-16T20:19:06.74+00:00

    In my opinion, Please select Destination as Microsoft OLE DB Provider for SQL Server to load the data into Database and it is replacement for SQL Native Client. I tried today 08/16/2024 1:00 PM PST. If this is helpful please upvote.


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.