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

J

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

PeterAtherton

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
Increasing number of rows beyond 65K 3
Pivot Table - 2
Embed the same Excel multiple times 0
Query not returning all the rows 8
Row Limit 65536 6
# of Rows Handled By Excel 1

Top