import dbase into excel XP limitations

  • Thread starter Thread starter chris
  • Start date Start date
C

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 ?
 
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...
 
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)
 
Back
Top