Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

PB 11 - Excel SaveAs 65000 rows limitation

2 posts in DataWindow Last posting was on 2008-10-10 15:17:34.0Z
RMK.B Posted on 2008-10-10 14:17:55.0Z
From: "RMK.B" <rammuralikrishnanb@zylog.co.in>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: PB 11 - Excel SaveAs 65000 rows limitation
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ef6413$1@forums-1-dub>
Date: 10 Oct 2008 07:17:55 -0700
X-Trace: forums-1-dub 1223648275 10.22.241.152 (10 Oct 2008 07:17:55 -0700)
X-Original-Trace: 10 Oct 2008 07:17:55 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87969
Article PK: 417225

Hi,

I am PB Version 11.0 Build 6525. Still the Datawindow SaveAs Excel has the
65536 rows limitations. The Excel 2007 option is not displayed in SaveAs
dialog box.

Any help to resolve the issue is appreciated.

TIA
Rammurali Krishnan B


Scott Morris Posted on 2008-10-10 15:17:34.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48ef6413$1@forums-1-dub>
Subject: Re: PB 11 - Excel SaveAs 65000 rows limitation
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ef720e$1@forums-1-dub>
Date: 10 Oct 2008 08:17:34 -0700
X-Trace: forums-1-dub 1223651854 10.22.241.152 (10 Oct 2008 08:17:34 -0700)
X-Original-Trace: 10 Oct 2008 08:17:34 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87971
Article PK: 417226


"RMK.B" <rammuralikrishnanb@zylog.co.in> wrote in message
news:48ef6413$1@forums-1-dub...
> Hi,
>
> I am PB Version 11.0 Build 6525. Still the Datawindow SaveAs Excel has the
> 65536 rows limitations. The Excel 2007 option is not displayed in SaveAs
> dialog box.
>
> Any help to resolve the issue is appreciated.

The current versions for Excel available in the Saveas dialog don't support
your requirements, so you need to find another way to achieve your goal.
CSV should work. Other options have been suggested before to similar posts.

Perhaps the bigger issue is why you are retrieving >200k rows in the first
place and then saving them to a file. There are better ways to move data
between sources; pipeline is one that comes to mind. In addition, there
many ETL tools available that might be better suited to your specific needs;
many dbms vendors provide these tools free.