I've been there and done something similar to what you need to do.

I used Access and created a linked table to the spreadsheet and another linked table to the staging table on SQL.

The data was then dumped into the staging table before being processed and put into the production tables.

Doing it this way, you can add things like "is not null" to ignore the empty rows at the start of the file at either end of import.

It's not the fastest thing in the world but it worked for me.