importing >64k rows into excel 2000

is there a method or setting that would allow greater than 64k record rows to be imported or opened in excel?? my crystal reports can export to excel files quite handily to any version from 4. to xp .xls files however, i cannot open them in excel itself,, i’ve tried .csv and .txt versions of the data but no-go there either..