Building excel sheet from bteq Export having more then 65K rows

Tools & Utilities
DP
N/A

Building excel sheet from bteq Export having more then 65K rows

Hi All,

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. 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 anybuddy ­have faced this type of situation.

Thanks