Importing Excel File To SQL Server (Opinions Please)

Dear All,
I am writing a procedure to import daily the customer excel file to SQL server 2000, I managed to do that where the excel file will be imported directly to the SQL server after creating the new data table, & then I need to read the created table & import it row by row to my original data table.The problem:

I.
       
The original excel file has the following:
a.
      
a protection password
b.
     
The contents has two merged headers (which effecting the import procedure)
c.
      
And last line is a totals line

Before importing the file I have manually to remove (a – b & c)!!
The Solution:

II.
    
I am trying to find a way to do the above points automatically inside the project.


III.
  
Also I thought of importing the excel file to a DataGrid first then:
a.
      
Let the user approve the file contents &
b.
     
Remove manually point (I.b.) above (I don’t now how yet, need to try it).
c.
      
Then import the DataGrid the the SQL server.
I think I prefer solution (III), any suggestions are highly appreciated
BR