Consider using DTS or BCP.
>
> i Have a table with a single field in SQL2000 and i want it to save into text file in continues format.
>Ex.
>Table1
>Field1
>rec1
>rec2
>rec3
>rec4
>rec5
>...
>
>is't possible to copy all the records in table1 to text file(Text1.txt) and the text file should look like this
>
>rec1rec2rec3rec4rec5...
>
>Thanks.
>ryan
--sb--