Exporting problem...

Hi --
I'm exporting a bunch of large excel files into a database. However I've come across a large problem. That is: lets say the excel file has 11000 lines, when I import it into the database.. the db is reading it as though it has 63000 lines. So I end up with my 11k with data in them, and 52000 blank entries in my db. Bad bad bad.

I have found a very clumsy way around this.. cut/paste the 11k real lines into a new excel file, then import that file into the db, but some of these files are 60k+ lines and it is going to be hard to cut/paste that size.

I'm wondering if it is somehow to do with having formulae in the excess cells... and excel/db is reading them as active.

Is there any relatively simple way for me to clear the contents of any lines that don't have my data in them?

Thanks for any suggestions.. i'm pulling my hair out at this point.