Hi Krishan,
YOu might want to try posting import/export type questions in the DTS forum.
Having said that, it sounds like you will want to use DTS to load the excel data to a MSSQL2K database. One of the easiest (and therefore coursest grained) approaches is to go to Start|Programs|Microsoft SQL Server|Import and Export Data. This will start up the import/export data wizard, which should lead you thru the loading of your Excel data to SQL.
HTH,
Steve.