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.)
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
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 | Other
3 answers
Sort by: Most helpful
-
Erland Sommarskog 122.3K Reputation points MVP Volunteer Moderator
2023-08-16T21:39:00.2933333+00:00 -
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
-
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.