Import Text file with Pipe Delimited - 2007

B

BLowry

I am trying to import a text file that is created using the pipe delimited (
| ) format. Access 2007 does not recognize this format and I can not figure
out how to fix this issue. Please advise me how I can import pipe delimited
files into Access 2007.

Thank you
 
J

Jerry Whittle

I just did it with Access 2007 so it can be done.

External Data Tab. Import box. Text File.

Browse for the file.

At the first Import Text Wizard window select Delimited.

At the second Import Text Wizard window put a | in the Other: box.

Follow through with the rest of the instructions.
 
B

Brian S

Jerry, I am having the same issues as BLowry. The system just beeps when I
try to use "|".

Version: Microsoft Access 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000)

Thanks Brian
 
B

BLowry

I have been trying to import Pipe Deliminted files into both Access and Exel
2007 versions. At this time I have not found a single way to get this to
work. Where is the Microsoft help? Why would you remove the ability for
Access and Excel to recognize "|" text pipe delimited?

Very bad MS Office bug!!!!
 
D

Debra Hill

Using a pipe delimiter works, but there is a trick to it. When you put your cursor in the field for the delimiter, you see the cursor as a straight bar. Sweep your mouse to the left as if you are selecting a space. When you see what looks like a space is selected, type the pipe.




BLowry wrote:

I have been trying to import Pipe Deliminted files into both Access and
12-Mar-10

I have been trying to import Pipe Deliminted files into both Access and Exe
2007 versions. At this time I have not found a single way to get this t
work. Where is the Microsoft help? Why would you remove the ability fo
Access and Excel to recognize "|" text pipe delimited

Very bad MS Office bug!!!

:

Previous Posts In This Thread:

Import Text file with Pipe Delimited - 2007
I am trying to import a text file that is created using the pipe delimited
| ) format. Access 2007 does not recognize this format and I can not figur
out how to fix this issue. Please advise me how I can import pipe delimite
files into Access 2007

Thank you

I just did it with Access 2007 so it can be done.External Data Tab.
I just did it with Access 2007 so it can be done

External Data Tab. Import box. Text File

Browse for the file

At the first Import Text Wizard window select Delimited

At the second Import Text Wizard window put a | in the Other: box

Follow through with the rest of the instructions
-
Jerry Whittle, Microsoft Access MV
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder

:

Jerry, I am having the same issues as BLowry.
Jerry, I am having the same issues as BLowry. The system just beeps when
try to use "|"

Version: Microsoft Access 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000

Thanks Bria

:

I have been trying to import Pipe Deliminted files into both Access and
I have been trying to import Pipe Deliminted files into both Access and Exe
2007 versions. At this time I have not found a single way to get this t
work. Where is the Microsoft help? Why would you remove the ability fo
Access and Excel to recognize "|" text pipe delimited

Very bad MS Office bug!!!

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Build a Cross-Browser ASP.NET CSS-Only Menu UserControl
http://www.eggheadcafe.com/tutorial...ce-d17d1b482676/build-a-crossbrowser-asp.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Data with | as the delimiter in Access 2007 6
Import Using Pipe as Delimiter 4
Problem importing large file 4
Import from notepad Pipe delimited text document 1
Import Trailing Spaces 8
Pipe Delimited files with headers 2
Export file to pipe-delimited format 1
Pipe-delimited files into access db 2

Top