Apr 07 2023 06:43 AM
Hi all , I downloaded an excel file recently that had over 250k row but when I open it it only shows me a total of 100k row ,even when I imported it into Microsoft SQL server it still shows the total is 100k row. Is there a way to get the excel to read all the 250k row the file supposed to have?
Apr 07 2023 07:09 AM
Apr 07 2023 08:44 AM
Apr 07 2023 08:56 AM
Do you mean in Excel for web you see 267000 rows and in desktop version 100000 rows? Or with what you reviewed data online?
Apr 07 2023 09:09 AM
Apr 07 2023 09:18 AM
That's more question to the support of online database. Total could show number of records in entire database, not number of records available for download, or that could be wrong number, whatever. If both Excel and SQL database show 100K that's what online source could allow you to download.