I usually use bulk insert to perform quick imports

I don't know what you're using but try this

Bulk Insert (Table_Name) From 'Input_FilePath'

With (FieldTerminator = 'Field_Delimeter',

RowTerminator = 'Row_Delimeter'

)

Or you can try simply replacing your line end params. with '\n'

MW

Edited by - mworku on 06/12/2003 9:00:55 PM