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 from excel file to sybase table

2 posts in General Discussion Last posting was on 2009-12-04 23:32:10.0Z
MSK Posted on 2009-12-04 21:46:21.0Z
Sender: 6e87.4b1982b7.1804289383@sybase.com
From: MSK
Newsgroups: sybase.public.ase.general
Subject: import data from excel file to sybase table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b19832d.6e94.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Dec 2009 13:46:21 -0800
X-Trace: forums-1-dub 1259963181 10.22.241.41 (4 Dec 2009 13:46:21 -0800)
X-Original-Trace: 4 Dec 2009 13:46:21 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28733
Article PK: 77976

Is there a way to import data from excel file to sybase
table?

Thanks
MSK


Rob V [ Sybase ] Posted on 2009-12-04 23:32:10.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <4b19832d.6e94.1681692777@sybase.com>
Subject: Re: import data from excel file to sybase table
Lines: 32
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b199bfa$1@forums-1-dub>
Date: 4 Dec 2009 15:32:10 -0800
X-Trace: forums-1-dub 1259969530 10.22.241.152 (4 Dec 2009 15:32:10 -0800)
X-Original-Trace: 4 Dec 2009 15:32:10 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28734
Article PK: 77975

Sure - export the data from Excel in CSV format.
Then create a table with the right columns, and import the CSV file into the
table using 'bcp -c', specifying the comma as the column separator (-t,).

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<MSK> wrote in message news:4b19832d.6e94.1681692777@sybase.com...
> Is there a way to import data from excel file to sybase
> table?
>
> Thanks
> MSK