Excel Data Import to SQL Server

Microsoft.Jet.OLEDB.4.0


SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\demo.xls', [Sheet1$])

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=E:\demo.xls;Extended Properties=Excel 8.0')...[Sheet1$]

Microsoft.ACE.OLEDB.12.0


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

SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0','Data Source=C:\Demo.xlsx;Extended Properties=Excel 12.0')...[Sheet1$]