mssql 엑셀파일 읽기

exec sp_configure 'show advanced options', 1
GO

RECONFIGURE
GO

EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO

RECONFIGURE
GO

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\excelDataFile.xlsx;', 'SELECT * FROM [Sheet1$]');