Why won't MS Access 2013 let me import a text file using the 'pipe' as the delimiter?

I am trying to import a pipe delimited text file into access, and when I am on the 'Import Text Wizard' screen and it asks me to choose the delimiter and I select Other and try using the keyboard key to have 'pipe" symbol go into the box I just get a beep????
shenryrgjAsked:
Who is Participating?
 
aikimarkConnect With a Mentor Commented:
There is only a single character allowed in that textbox.  Delete the contents of that textbox and try to enter the pipe character again.
0
 
Rey Obrero (Capricorn1)Commented:
maybe your text file format is not delimited

try selecting the Fixed width in the wizard
0
 
shenryrgjAuthor Commented:
Thank you - there must have been a space or something there already that I did not see - once I did a backspace to clear that box, I was able to successfully put the 'pipe' symbol there as the delimiter.
0
 
joe gCommented:
Wow. If you only knew how many times and different methods I tried before reading this. Funny thing is when I did an "Open other" it let me put the pipe in.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.