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

G

Guest

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.
 
G

Guest

Jacob said:
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.
Click to expand...

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

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I view a Dbase file with more than the 65k records that E. 3
I want to actually reduce the number of rows & columns in a worksh 3
Pivot Table - 3
# of Rows Handled By Excel 1
Row Limit 65536 6
How do i get the 65k of rows to go away?? 8
Excel Range : Row limit 2
Excel Range issue 2

Top