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

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.

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

"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