Solved

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

Posted on 2015-01-19
4
505 Views
Last Modified: 2016-11-02
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????
0
Comment
Question by:shenryrgj
4 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40558414
maybe your text file format is not delimited

try selecting the Fixed width in the wizard
0
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 40558481
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
 

Author Closing Comment

by:shenryrgj
ID: 40558650
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
 

Expert Comment

by:joe g
ID: 41870162
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now