How to breakthrough row number limitation

  • Thread starter Thread starter Billy Leung
  • Start date Start date
B

Billy Leung

Hi all,

The default row number limitation for each sheet is 65,536. Is it possible
to increase it up to 100,000 ? Your help would be appreciated.


Billy
 
No. You'll have to use multiple columns or multiple worksheets (or
another app, like Quattro Pro or Access).
 
Hi JE McGimpsey, thank you so much for your prompt response.

My situation is -- I need to import a dbf file which the record is more than
65,536. How should I do to make it?

Billy
 
Billy Leung wrote...
....
My situation is -- I need to import a dbf file which the
record is more than 65,536. How should I do to make it?
Click to expand...

Is this DBF file sorted? If so, you could use multiple queries against
it to pull in all records into multiple worksheets.
 
Hi,
If you goto save as, and then pick HTML, it will give you the option to
publish as a web page. Then add functionality, and click on the Open in Web
Browser, and Bingo!! Columns upto ZZZ and Rows upto 240,000-odd! Its the
only way I know....


Hth,
Oli
 
Harlan said:
Billy Leung wrote...
...

Is this DBF file sorted? If so, you could use multiple queries against
it to pull in all records into multiple worksheets.
Click to expand...

It could be complex to determine for sure that each of the multiple
queries is less than the row limit. Instead, consider the following
approach:

Dim Counter As Long
With ThisWorkbook
Do While Not rs.EOF
Counter = Counter + 1
.Worksheets(Counter).Range("A1") _
.CopyFromRecordset rs
Loop
End With

Jamie.

--
 
Back
Top