OPENROWSET

SELECT * FROM OPENROWSET (
	'Microsoft.ACE.OLEDB.12.0', 
	'Excel 12.0;Database=ExcelPathFile.xlsx;HDR=YES' , 
	[Sheet1$]) 

Enabled Ad Hoc Distributed Queries

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
GO
EXEC SP_CONFIGURE 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO

Provider OLEDB

USE master
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1
GO

Export to Excel

INSERT INTO OPENROWSET(
	'Microsoft.ACE.OLEDB.12.0', 
	'Excel 12.0 Xml;Database=ExelPathFile.xlsx;HDR=YES', 
	[SheetName$]
) SELECT * FROM TableName;