We have an application that is exporting 1,254,236 records to a .csv file. The file size is 295,788. Excel brings up an error msg that it was unable to load the full file. I have a batch job that successfully splits the file into smaller ones which works ok. However, when I try to reconcile the counts, it doesn't match the number exported by the application.
Is there a size limit for .csv files?
Thanks for your help.