if you will use ssis

pls follow given steps.

(1)create excle connection..

(2) go to excel sourse after that Data acess mode:sql commane

SELECT TOP 100 *

FROM [Sheet1$]

(3) after map the excel sourse to oledb destination...