Microsoft Access Database Engine 2016 Best

Your ETL server shouldn’t have Excel installed. But with the ACE engine, a simple SELECT * INTO SQLServerTable FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;HDR=YES;DATABASE=C:\data.xlsx','SELECT * FROM [Sheet1$]') works beautifully.

Windows 7, Windows 8, Windows 10, Windows 11, or Windows Server equivalents. microsoft access database engine 2016