Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE

(Diana Moldovan)Sometimes you need to quickly reference the content of an Excel file in a SQL Server T-SQL script, however, this may not be as simple as it seems. In this tip I’ll offer solutions for a few of the most common problems that may affect you when trying to read an Excel file using OPENRO

Register to Read