-
Separating unwanted string from text file
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|