<div>
maybe your text file format is not delimited<br />
<br />
try selecting the Fixed width in the wizard
</div>


maybe your text file format is not delimited

try selecting the Fixed width in the wizard

<div>
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.
</div>


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.

<div>
Wow. If you only knew how many times and different methods I tried before reading this. Funny thing is when I did an &quot;Open other&quot; it let me put the pipe in.
</div>


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.

<div>
<div class="content wysiwyg-content">
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&quot; symbol go into the box I just get a beep????
</div>
</div>


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????

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.