Inserting values from a text file into Sybase SQL server?

Question

I have a text file (i.e. practice.txt) like the following:

COW29,104,F
DUCK49,20,D
BAT2,8,F
FISH52,3,F

except it has thousands of lines.

I would like to write an script that will insert all the rows into a Sybase SQL table like:

 name | number | class
 ---------------------
COW29  | 104    | F
DUCK49 | 20     | D
BAT2   | 8      | F
FISH52 | 3      | F

Thanks!

Answer 1

Try below command

bcp db_name..table_name in file_name -S server -U user -Ppswd -t',' -c