SQL OpenDataSource read Excel from Network location
I am trying to use OPENDATASOURCE to read an Excel file in Sql Server management Studio.
SQL Server Access
I jave a domain admin user – can login to SQL server 2016 through RDP, and can connect to SQL using Windows credentials in SQL Server Management Studio (SSMS).