Excel adding blank rows when sorting

[millerli26]

I have a list of customers our company sends birthday cards when they
come around. I am importing the list from Access to Excel and then
using Sort to put them in order of month and then day, both descending
so that I can delete everything but the month that I need. Excel puts
all the customers with blank birthdate fields at the top just as it did
before so I can delete them, but now below those fields it has blank
rows from 2700-4139 before it begins with the January birthdays and
continues on as normal.

Does anyone know why this might be happening?

 

[Guest]

Wouldn't it be a lot easier to set up your Access query to extract only the
records you want?

 

[millerli26]

Well, of course it would! Sometimes I just do what I'm told and don't
think of ways I can improve things that were made before I got here.

Thanks a bunch