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.

Returned data to excel

2 posts in General Discussion Last posting was on 2007-05-23 14:02:13.0Z
George Palaigeorgiou Posted on 2007-05-22 16:47:24.0Z
Reply-To: "George Palaigeorgiou" <gpalegeo@evergreen.gr>
From: "George Palaigeorgiou" <gpalegeo@evergreen.gr>
Newsgroups: ianywhere.public.general
Subject: Returned data to excel
Lines: 17
Organization: EG Co
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3959
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 85.73.250.152
X-Original-NNTP-Posting-Host: 85.73.250.152
Message-ID: <46531e9c@forums-1-dub>
Date: 22 May 2007 09:47:24 -0700
X-Trace: forums-1-dub 1179852444 85.73.250.152 (22 May 2007 09:47:24 -0700)
X-Original-Trace: 22 May 2007 09:47:24 -0700, 85.73.250.152
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6020
Article PK: 2482

Hello

I have created a simple select SQL query that is presented perfectly in
Microsoft Query (when importing data to MS Excel 2007) but when I click
"Return data
to Excel" then Excel presents the data truncated to 8 characters and also
confuses Greek encoding.

(MS Office 2007, Database: Sybase Anywhere 6 - from "Micros" system)
I have already check the issues of IMEX and TypeGuessRows

I would aprecciate very very very much any help

Thanks in advance
George


Rob Waywell Posted on 2007-05-23 14:02:13.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <46531e9c@forums-1-dub>
Subject: Re: Returned data to excel
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <46544965$1@forums-1-dub>
Date: 23 May 2007 07:02:13 -0700
X-Trace: forums-1-dub 1179928933 10.25.98.235 (23 May 2007 07:02:13 -0700)
X-Original-Trace: 23 May 2007 07:02:13 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6023
Article PK: 2481

Your best starting point for help with this is Micros Tech Support. They
will be the most familiar with the configuration, schema, and data types
used in their database.

The most likely explanation for the confused Greek encoding is that you need
to have character set translation turned on. The data truncation issue is
less obvious but again the right place to start is to work with Micros Tech
Support.

Note that you are using an old version of Adaptive Server Anywhere. The
current released version is 10.0.1.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"George Palaigeorgiou" <gpalegeo@evergreen.gr> wrote in message
news:46531e9c@forums-1-dub...
> Hello
>
> I have created a simple select SQL query that is presented perfectly in
> Microsoft Query (when importing data to MS Excel 2007) but when I click
> "Return data
> to Excel" then Excel presents the data truncated to 8 characters and also
> confuses Greek encoding.
>
> (MS Office 2007, Database: Sybase Anywhere 6 - from "Micros" system)
> I have already check the issues of IMEX and TypeGuessRows
>
> I would aprecciate very very very much any help
>
> Thanks in advance
> George
>
>