Importing text file

[jimny]

I do not have much experience with SQl but...

I am running sql server 2000 and am trying to import a text file that looks like:

|Lots-Land & Acreage|,|02/26/2003|,|03/12/2003|,||,||,||,|250,000|,
|HOPEWELL|,|Beautiful Farm Land, lakes, streams, lots of animals.|,||

I have tried the import utility, but it breaks the text string on the commas in the text string as if they were new columns. Is there some way to get it to break on "|,|" only? or do I have to create my own array and then loop through that inserting each element as I go through it?

 

[JayKusch]

Is it possible to a replace on |,| and substitute just a plain | or another character such as @ or * ??? Then run it through the SQL Import feature based on the new character based delimiter
Thanks

J. Kusch