Forum Discussion
More than 1,048,576 rows
I have been sent a 4.4GB Excel .CSV file. It has 16columns, but several million rows. When I try to open it, it only opens the first 1,048,576 rows. Is there a way to open the whole file? I don't min...
To my knowledge - no. You may split csv on several files and open them one by one. Or import into the Excel using legacy wizard, it has an option from which row to start importing. Something like this.
Yes, exactly, that could add some logic for splitting rather than simple batch file which splits based on number of rows.
And perhaps it's not necessary to return data back to Excel sheet, load to data model and work with it aggregating data.