Hi ,
I have one excel file in zipped format which contains data with size 157 MB. It's original size is 2.6 GB so to send to user I zipped the file.
Now user is saying unable to open the file at once because of huge size and want to split the excel file into 3 files randaonly and zip them.
Could you please guide me on how to do this?
OS -- Windows 7
Regards,
Maddy
But, why is it so big? That answer will help you determine if the file can be easily broken up.
If it is big because there are so many lines of data, how about
save to a .csv file
then use the unix split command to break into several smaller files (each containing x number of rows)
Then you email file in ten chunks (or however many), and the user appends file 2 to end of file 1, then appends file 3, etc...