This can be run only in server

EXEC 'TABLENAME','PATH'

CREATE PROCEDURE BULKINSERTEXCEL

(

@tablename nvarchar(500) ,

@PATH nvarchar(500)

)

as

DECLARE @sSQL nvarchar(500)

SET @sSQL ='SELECT * INTO '+ @tablename +' FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 12.0 Xml;IMEX=1;Database='+@PATH+';'', ''SELECT * FROM [SHEET1$]''); '

EXEC sp_executesql @sSQL