Import data from Excel to SQL server or vice versa

hi,

I want to upload an excel file into the SQL server through Tsql Code.

please suggest me the way so that i can reduce my time.

thanks.

Create a linked server (using the ODBC provider) and you can then refer to it using TSQL.