Export text file to a table

[saad]

Anbody please help
I am trying to export a text file to a table using enterprise manager
and all tasks
But the process keeps adding strange charater like squares at the end
of each line and also replaces each empty line in the text file with a record in the table with that square type character. I used the following code to delete all rows with that character (as a work around) but no joy. I am losing hope.

Code is
DELETE FROM table1
WHERE column1 = ' '

[Tanya]

Is there anyway you can convert the text file to a csv file? (excel)
Try making the file .csv file format it so that it will be delimited and then try the import.


------------
saad at 12/5/00 9:29:09 AM

Anbody please help
I am trying to export a text file to a table using enterprise manager
and all tasks
But the process keeps adding strange charater like squares at the end
of each line and also replaces each empty line in the text file with a record in the table with that square type character. I used the following code to delete all rows with that character (as a work around) but no joy. I am losing hope.

Code is
DELETE FROM table1
WHERE column1 = ' '