importing csv file into sybase sql server 11.0.x

[drme...@my-dejanews.com]

Hi everyone,

I just got sybase up and running on my linux box, everything appears to work
fine but i'm missing something. I'm lookin for a feature to import a csv
(comma separated file) into a table in my new sybase database. I know MySQL
had a feature "LOAD DATA INFILE" but i seem to not find that feature in the
manuals for sybase.

If anyone have a solution i'd be forever in debt or at least very greatfull.

Sincerely,

Mats Nordgren.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[Anthony Mandic]

drme...@my-dejanews.com wrote:

> I just got sybase up and running on my linux box, everything appears to work
> fine but i'm missing something. I'm lookin for a feature to import a csv
> (comma separated file) into a table in my new sybase database. I know MySQL
> had a feature "LOAD DATA INFILE" but i seem to not find that feature in the
> manuals for sybase.

You want 'bcp' the bulk copy utility.

-am