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.

Download Excel data to sybase table through Powerbuilder

4 posts in DataWindow Last posting was on 2009-12-08 16:31:37.0Z
MSK Posted on 2009-12-05 01:29:58.0Z
Sender: 6e87.4b1982b7.1804289383@sybase.com
From: MSK
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Download Excel data to sybase table through Powerbuilder
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b19b796.736c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Dec 2009 17:29:58 -0800
X-Trace: forums-1-dub 1259976598 10.22.241.41 (4 Dec 2009 17:29:58 -0800)
X-Original-Trace: 4 Dec 2009 17:29:58 -0800, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90404
Article PK: 410009

Does any one knows how to import Excel ( XLS file ) data
into Sybase database through Powerbuilder or Sybase command?

Thanks


fisher <fisher_NO Posted on 2009-12-05 11:23:05.0Z
From: fisher <fisher_NO@SPAM_star.wckp.lodz.pl_PLEASE>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Download Excel data to sybase table through Powerbuilder
References: <4b19b796.736c.1681692777@sybase.com>
In-Reply-To: <4b19b796.736c.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091125-1, 11/25/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b1a4299$1@forums-1-dub>
Date: 5 Dec 2009 03:23:05 -0800
X-Trace: forums-1-dub 1260012185 10.22.241.152 (5 Dec 2009 03:23:05 -0800)
X-Original-Trace: 5 Dec 2009 03:23:05 -0800, vip152.sybase.com
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90405
Article PK: 410011


MSK wrote:
> Does any one knows how to import Excel ( XLS file ) data
> into Sybase database through Powerbuilder or Sybase command?
>
> Thanks

Have you tried OLE ? - there's an example on codexchange.
Another one could by old good ODBC, but you have to name areas and then
those will be available as tables


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-05 14:33:28.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b19b796.736c.1681692777@sybase.com> <4b1a4299$1@forums-1-dub>
Subject: Re: Download Excel data to sybase table through Powerbuilder
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4b1a6f38$1@forums-1-dub>
Date: 5 Dec 2009 06:33:28 -0800
X-Trace: forums-1-dub 1260023608 10.22.241.152 (5 Dec 2009 06:33:28 -0800)
X-Original-Trace: 5 Dec 2009 06:33:28 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90406
Article PK: 410010

If you define it as an ODBC data source you could use pipelines to move it.

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"fisher" <fisher_NO@SPAM_star.wckp.lodz.pl_PLEASE> wrote in message
news:4b1a4299$1@forums-1-dub...
> MSK wrote:
>> Does any one knows how to import Excel ( XLS file ) data
>> into Sybase database through Powerbuilder or Sybase command?
>>
>> Thanks
> Have you tried OLE ? - there's an example on codexchange.
> Another one could by old good ODBC, but you have to name areas and then
> those will be available as tables


Terry Dykstra [TeamSybase] Posted on 2009-12-08 16:31:37.0Z
Reply-To: "Terry Dykstra [TeamSybase]" <dontreply_tddykstra@forestoil.ca.x>
From: "Terry Dykstra [TeamSybase]" <tddykstra@forestoil.ca>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b19b796.736c.1681692777@sybase.com> <4b1a4299$1@forums-1-dub> <4b1a6f38$1@forums-1-dub>
Subject: Re: Download Excel data to sybase table through Powerbuilder
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b1e7f69@forums-1-dub>
Date: 8 Dec 2009 08:31:37 -0800
X-Trace: forums-1-dub 1260289897 10.22.241.152 (8 Dec 2009 08:31:37 -0800)
X-Original-Trace: 8 Dec 2009 08:31:37 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90415
Article PK: 410021

Pipeline works, but you must define the first row in the spreadsheet to have
the column names and you must create a named range for all the data.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:4b1a6f38$1@forums-1-dub...
> If you define it as an ODBC data source you could use pipelines to move
> it.
>
> --
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
>
> "fisher" <fisher_NO@SPAM_star.wckp.lodz.pl_PLEASE> wrote in message
> news:4b1a4299$1@forums-1-dub...
>> MSK wrote:
>>> Does any one knows how to import Excel ( XLS file ) data
>>> into Sybase database through Powerbuilder or Sybase command?
>>>
>>> Thanks
>> Have you tried OLE ? - there's an example on codexchange.
>> Another one could by old good ODBC, but you have to name areas and then
>> those will be available as tables
>
>