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

Tools

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

Hi All,

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.

Thanks
5 REPLIES
Teradata Employee

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

TPT (Teradata Parallel Transporter) can do the export to csv for you, much easier than using bteq or fastexport, etc.

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.
Teradata Employee

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

not sure if TPT has that functionality, but here is a way to split then get into excel as multiple spreadsheet

http://bytes.com/topic/visual-basic-net/answers/605945-split-large-text-file-number-lines

http://en.kioskea.net/forum/affich-13781-macro-that-takes-multiple-csv-files-and-puts

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

Thanks.. But how we can implement this in a JOB cycle in UNIX env. above links are using .net tech. which i cant use , though i can use java..
Teradata Employee

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

you can write the data into Excel XML format, which supports multi-sheet, convert the following simple program at below link into perl should be a trivial matter.

http://www.codeproject.com/KB/aspnet/Export_to_Excel.aspx