Building excel sheet from bteq Export having more then 65K rows
I have requirement where I have to build(genrate) an excel sheet from a table but it can have more then 2Lakh - 3Lakh records and as we all know one excel sheet cant have more then 65K records so more then 65K records should be on next sheet in the same excel sheet and this process will be part of job on UNIX Box.
using BTEQ EXPORT ? or anything else?
And second that excel sheet should be stored into database table as BLOB data. does any buddy have exp in java or c lang. bec I am not sure how we can achieve this.
Please share your ideas if anybudy have faced this type of situation.
Re: Building excel sheet from bteq Export having more then 65K rows
Thanks ... But my main concern is how can i build excel sheet from that csv . or can we use somthing like shell script or any codition in bteq export or TPT so that records > 65K will build new excel sheet or will put records in second tab of that excel sheet.