DesertCyclist,

FYI, this question is probably more appropriate for
microsoft.public.excel.misc or a SQL Server newsgroup, but I'll take a shot
at it.

When you filter records, what is the range of cells that are being filtered?
Is there data below this table being filtered? Does this table have a named
range?

When you import into SQL Server, are you importing by sheet name or by a
named range?

In XL, do a [Ctrl] + [End] key combination. What cell do you end up at?
Are you 1000+ rows below your last row of data? Maybe you are importing a
bunch of blank rows into SQL Server.

Write back, answering those questions and check the last cell in XL. I
might be able to help you figure this out.

HTH,

Conan









"DesertCyclist" wrote in message
...
I have a spreadsheet with a field that may contain blanks (empty). When I
filter on that field to show only the blanks, I get 4000 records returned.
But if I import the spreadsheet into SQL Server, the test in there for
blanks
('') returns nothing. However, if I test for Nulls in that field, I get
5000
records returned. I don't know which one (Excel or SQL Server) is giving
me
the right answer. Can anyone help me understand what's going on?

Thanks!