5 ms·
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.
by bhartzer 12y ago
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.
- morganherlocker 12y agoThe 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.