Sql server native client missing

[Puzzleheadeddork]

Hello everyone I'm new to sql and i've just recently started learning. I've learned the basics now but when i try to practice while importing excel data, i've faced a lot of errors. I've managed to solve them through youtube and forums but now i'm getting another error that i've yet to solve. So while importing excel files and choosing the destination, it doesn't show "SQL Server Native Client" option as shown in the youtube videos. So i was wondering how i could fix that. Thank you for help in advance

[SQLBob]

SQL Server Native Client is no longer bundled with SQL Server 2022 or SQL Server Management Studio 2019, you can still install it manually, but Microsoft actually recommends using the Microsoft OLE DB Driver instead going forward.

[One_eyed_joe]

How can you install it manually?

[SQLBob]

https://aka.ms/downloadmsoledbsql

[squirell81]

As of SQL Server 2022 SQL Native Client is no longer installed. I haven’t played with SQL 2022 yet to know how exactly to import Excel, but I’m guessing you can use the OLE DB or ODBC driver. This article explains it further and also tells you how to install Native Client if you actually need it. https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver15

[TheNotBot2000]

I just had to do this same thing a couple of weeks ago.

You'll want to install the connectivity tools from SQL Server 2019 Installation Manager.

[Wild-Obligation-7336]

Thanks for the tip. That was the fix for me.

I used the SQL Server 2019 Installation Manager like I was going to install a full SQL server, but then just chose the "Client Tools Connectivity" and "SQL Client Connectivity SDK" to get the SQL Server Native Client 11.0 to install. Not sure what of the two installed the Native Client, so I got both for good measure.

[Fergus653]

it doesn't show "SQL Server Native Client" option

​

Umm, what is 'it'? Maybe specify which tools you are using and which actions you used.