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.

BCP problem...

2 posts in Windows NT Last posting was on 2001-03-16 04:37:58.0Z
JC Posted on 2001-03-15 00:47:39.0Z
From: jc
Date: Wed, 14 Mar 2001 19:47:39 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: BCP problem...
Message-ID: <8A2CC1886D6199C300045CBF85256A10.00045CCE85256A10@webforums>
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1101
Article PK: 1087703

I have been trying to BCP an excel spreadsheet to ASE 12.0 for a couple of
days now and I am failing over and over again. I have been forced to learn
a bit more about the BCP command and its parameters than I would have
liked.

When the command runs I get a message repeating many times like:


cs_convert: cslib user api layer: common library error: The datatype value
is outside the domain of legal values for the datatype.


After that message finishes repeating, I get the message:

Text/Image field is larger than the maximum value. Data truncated.
Unexpected EOF encountered in BCP data-file.
bcp copy in failed.


This excel spreadsheet was exported from an msaccess table. Can anyone
please help me? Thanks in advance.


Jim Egan Posted on 2001-03-16 04:37:58.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: BCP problem...
Date: Thu, 15 Mar 2001 21:37:58 -0700
Message-ID: <MPG.151b4696f828103498b1ae@forums.sybase.com>
References: <8A2CC1886D6199C300045CBF85256A10.00045CCE85256A10@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 6
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1094
Article PK: 1087696

Please do not cross post your question to multiple newsgroups.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com