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
621 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

734 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