Use OLEDB to connect to the excel.
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
"SELECT * FROM [sheet1$]"
The worksheet name should be followed by a $
You can then read from the excel (as from a table ) using a recordset
and push the data into the required destination.
I hope this might help you.