Excel to MSSQL

hi

i have an excel sheet with 2 columns
regno name
-- --
and a table regdetails of the form

regdetails
(
regno bigint
name varchar(30)
)

my requirement is to export the data from excel sheet to the table.
the excel sheet may have duplicate entries but i want only distinct
records to be exported to the table.

can i create a DTS package to perform this ?

please post ur commentsYes you can accomplish this with DTS, import to a temp table and delete duplicate rows then copy to original table. May check http://www.sqldts.com website for more information.