import text file into sybase table

[mark1110]

Hi,

I need to import a text file on a unix server to a sybase table. The text file (mailing.txt) is comma delimited:

name, address, city, state, zip, county

The sybase file (maillist) I want to import the text file into is:

name char(35)
address char(50)
city char(35)
state char(2)
zip char(5)
county char(20)

I was looking at the bcp command but I am not sure how to use it. Can anyone help me?

Mark

 

[PDreyer]

You can get more info about bcp from

http://infocenter.sybase.com/help/i...focenter.dc30191.1550/html/utility/X14951.htm

Where are you getting stuck
Comma delimited can cause problems if your data contain commas e.g. a comma inside the address