Hi,
I have a tool that I have developed where you can select a range in the Excel sheet and then unselect unwanted rows and columns.
Then you can also map the selected columns to the SQL Server columns in the table where you would like to store the Excel data.
I will release the software as commercial but I give away licenses for another week or so to people in the SLQ/BI area to get feedback.
If you are interested of a copy, sign up for a trial on
www.sqlspreads.com or send me an email at johannes.akesson@obnex.com and I can help you to get started.
Best regards
Johannes Akesson