how can i read data from Spreadsheet (Excell) to SQL Server 2000?

i have data on a spreadsheet and i need to read it to a table in SQL server ? how can i do that ? some one refere to me a method for that but i need to see what other think is the best option and the most effecienet way let us say!!

Depend on Excel file structure
if it is fixed - like a table - then use jet (if you doing it from within asp.net app).
if it is not fixed use excel object model

if youi want to do it from within sql server (without application services) then simple use dts package..

|||

You can use DTS to transfer the data from excell to SQL Server.

|||

Try the thread below for code using Excel as linked server. Hope this helps.

http://forums.asp.net/1019602/showpost.aspx

|||can you give me a link or a solution for all cases whether from asp.net or from sql server !!? thanks