Hello Sir, I am trying to import a table in xls format in my database but i don't have an option to choose 'SQL Server Native Client' as my Destination in 'SQL Server Import and Export Wizard' can you please share how can i fix this?
Hello Manyank SQL Server Native client was removed in Latest SQL Server 2022.U can use Latest Microsoft ODBC Driver for SQL Server going forward. Here what else we can do is Switch to latest Microsoft ODBC Driver for SQL Server or Install 2012 Native Client The above 2 links are useful learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver16 www.microsoft.com/en-US/download/details.aspx?id=50402 *Thanks & Regards* MS SQL DBA TECH SUPPORT
Its not issue... its limited edition..if you want agent then you need to upgrade to editions like standard,enterprise which all depends on your budget and needs
That's great to hear! Positive feedback and appreciation from viewers can be very encouraging for content creators at all the times Thanks & Regards MS SQL DBA TECH SUPPORT