How can I surpass/modify the Excel limit of 65k rows?

[Jacob]

I need to open a document in Excel which exceeds the 65k row maximum per
worksheet. The information is in a dif extension, and not xls. Is there a way
to bypass or expand the 65k row maximum OR open the data on multiple
worksheets?
Thanks.

[PeterAtherton]

"Jacob" wrote:

> I need to open a document in Excel which exceeds the 65k row maximum per
> worksheet. The information is in a dif extension, and not xls. Is there a way
> to bypass or expand the 65k row maximum OR open the data on multiple
> worksheets?
> Thanks.

You might be able to do this in Access, and run queries to split the data
and move it into Excel.

Peter