import dbase into excel XP limitations

[chris]

I imported successfully a dbase iv db with excel XP but the db has about
95000 records and excel can only show about 65000. I tried to import it as a
database with a filter that would show the remaining 30000 records but it
only shows the headers. I even tried to open it in access 2000 but stil I
can only view the headers. How can I access the last 30000 records ?

 

[chris]

Precision:
The dbf file opens with Excel XP and shows all records only via File/Open.
Using the import data function shows only the headers and no records...

 

[WojciechG]

Ue MS Query or SQL Function with "WHERE" statement or SQL.Retrieve with partition (first 30000 recs into sheet#1, next set into Sheet#2 and so on)