June 21, 2016 at 9:02 am
Hi All,
I am having a hard time importing a text file that was given to me that is delimited by 3 pipes.
I am manually importing by right clicking on my database and choosing Tasks...Import Data
When I get to the Column Delimiter section I have tried the following with no luck
{|||} and I have tried {|}{|}{|}
Any help is greatly appreciated...
June 21, 2016 at 9:24 am
Remove the braces and just leave the pipes. Then click refresh.
If it doesn't work, copy the delimiter from the file and paste it in the column delimiter field.
June 21, 2016 at 9:25 am
How about selecting one pipe as your delimiter and then throwing away the empty columns?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 21, 2016 at 9:25 am
1. Create the table
2. Use BCP and specify the field terminator as the "|||"
A possible command, fill in the blanks to fit your environment
BCP Database.Schema.Table IN C:\bcp\ImportThis.txt /m 100 /b 100 /e C:\bcp\ImportThis.err /c /r /f "|||" /S Server /T
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 21, 2016 at 9:37 am
brianconner (6/21/2016)
Hi All,I am having a hard time importing a text file that was given to me that is delimited by 3 pipes.
I am manually importing by right clicking on my database and choosing Tasks...Import Data
When I get to the Column Delimiter section I have tried the following with no luck
{|||} and I have tried {|}{|}{|}
Any help is greatly appreciated...
If you received an error message, can you post it, please?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 21, 2016 at 11:41 am
Thank you very much.....
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply