Forum Discussion
Excel file with 260k rows
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...
How do you know it contains 250K rows?
Is the worksheet filtered, or have some rows been hidden?
Is the worksheet filtered, or have some rows been hidden?
I reviewed the data online before I downloaded it and it showed 267k entry , I tried to unhide rows but nothing happened
Do you mean in Excel for web you see 267000 rows and in desktop version 100000 rows? Or with what you reviewed data online?
- In the total online data base I downloaded it from
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.
