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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

744 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

16 Experts available now in Live!

Get 1:1 Help Now