Hacker News Reader

Excel can only handle a certain amount of records. I've personally found it hard to deal with more than 100,000 rows in Excel.

View on HN

The limit went up considerably with the introduction of 64-bit Excel. Also, there is a plugin called "Power Query" that allows the actual data to be stored in MSSQL. I have seen this work on tables with 100s of millions of records without a hitch.

Reply on news.ycombinator.com