how to import excel sheet to sql server table using t sql query

INSERT INTO tablename(tblname, synonymname)
SELECT A.[Column1], A.[Column2]
FROM OPENROWSET
('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Users\rc07973\Desktop\synonym.xlsx;HDR=YES',
'select * from [Sheet1$]') AS A;

or
BULK INSERT TblSynonymsname
FROM 'C:\Users\rc07973\Desktop\synonym.txt'
WITH ( FIELDTERMINATOR =',', FIRSTROW = 2 )
or
BULK INSERT TblSynonymsname
FROM 'C:\Users\rc07973\Desktop\synonym.csv'
WITH
(
    FIRSTROW = 2,
    FIELDTERMINATOR = ',',  --CSV field delimiter
    ROWTERMINATOR = '\n',   --Use to shift the control to next row
    TABLOCK
)