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.

import data into sqlanywhere 9 f

2 posts in General Discussion Last posting was on 2003-09-02 13:39:21.0Z
kris Posted on 2003-08-29 20:27:26.0Z
Sender: 2f5f.3f4fb5ff.1804289383@sybase.com
From: kris
Newsgroups: ianywhere.public.general
Subject: import data into sqlanywhere 9 f
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f4fb768.2f65.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 29 Aug 2003 13:28:24 -0700, 10.22.241.42
Lines: 19
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Aug 2003 13:25:45 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Aug 2003 13:27:26 -0700
X-Trace: forums-1-dub 1062188846 10.22.108.75 (29 Aug 2003 13:27:26 -0700)
X-Original-Trace: 29 Aug 2003 13:27:26 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1684
Article PK: 3909

hi,
I have tried import data from txt file into sqlanywhere
table.This table contains column "createdate" datatype
datetime. while running the following command, I got
error, the error is " cannot convert to a timestamp. the
badvalue was supplied for column 'createdate' on line 1 of
the data file

i have tried "LOAD TABLE EMPLOYEES FROM 'C:\EMPLOYEES.TXT'
CHECK CONSTRAINTS OFF


The txt file was created by SQLServer BCP with 'Character'
format

Any suggestions?

Thanks
kris


Nick Elson Posted on 2003-09-02 13:39:21.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3f4fb768.2f65.846930886@sybase.com>
Subject: Re: import data into sqlanywhere 9 f
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <3f549dd0$1@forums-2-dub>
X-Original-Trace: 2 Sep 2003 06:40:32 -0700, nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Sep 2003 06:37:18 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Sep 2003 06:39:21 -0700
X-Trace: forums-1-dub 1062509961 10.22.108.75 (2 Sep 2003 06:39:21 -0700)
X-Original-Trace: 2 Sep 2003 06:39:21 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1689
Article PK: 3911

Did you forget to add the

FORMAT BCP

clause?

<kris> wrote in message news:3f4fb768.2f65.846930886@sybase.com...
> hi,
> I have tried import data from txt file into sqlanywhere
> table.This table contains column "createdate" datatype
> datetime. while running the following command, I got
> error, the error is " cannot convert to a timestamp. the
> badvalue was supplied for column 'createdate' on line 1 of
> the data file
>
> i have tried "LOAD TABLE EMPLOYEES FROM 'C:\EMPLOYEES.TXT'
> CHECK CONSTRAINTS OFF
>
>
> The txt file was created by SQLServer BCP with 'Character'
> format
>
> Any suggestions?
>
> Thanks
> kris