This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 22%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
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.)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 3%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Please select Destination as Microsoft OLE DB Provider for SQL Server
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.
No, it is not, but you are pardoned, because it certainly is confusing.
Microsoft OLE DB Provider for SQL Server is the long name for the very old SQLOLEDB that came with SQL 2000 and which ships with the OS. The one you have in mind is Microsoft OLE DB Driver for SQL Server, or MSOLEDBSQL.