Building excel sheet from bteq Export having more then 65K rows
I have requirement where I have to build(generate) an excel sheet from a table but it can have more then 2 -3 lakh 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. doesany buddy have exp in java or c lang. bec I am not sure how wecan achieve this.
Please share your ideas if anybuddy have faced this type of situation.