Hi.. I have a problem with inserting data from text file into a table on SQL. The problem I'm having is that the text file provided has a lot of unwanted string that causes bcp operation failed. I wanted to insert the text data into a table. Usually I would use bcp operation to do that, however the newest text file I've got has some unwanted string that causes bcp to fail. I can insert the data into a table, but because the data is horizontally long in view, it would not be inserted according to the right row, meaning that the second row data would still be half of the first row data. Anyone know how to insert the data in a correct manner ? thanks.