Youâ(TM)re right. 10,000 Rows in Excel is nothing and can be handled very efficiently. I donâ(TM)t recommend it, but I have power queried almost 700,000 Rows into Excel before. It can handle high volume. However, when you have tens of thousands of records with duplicated values in portions of the Rows, the relational data structure that SQL and it various derivatives provide is unparalleled.
Slashdot Mirror
Youâ(TM)re right. 10,000 Rows in Excel is nothing and can be handled very efficiently. I donâ(TM)t recommend it, but I have power queried almost 700,000 Rows into Excel before. It can handle high volume. However, when you have tens of thousands of records with duplicated values in portions of the Rows, the relational data structure that SQL and it various derivatives provide is unparalleled.