Import Text file with Pipe Delimited - 2007

Discussion in 'Microsoft Access External Data' started by BLowry, Feb 12, 2010.

  1. BLowry

    BLowry Guest

    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
     
    BLowry, Feb 12, 2010
    #1
    1. Advertisements

  2. 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, Feb 12, 2010
    #2
    1. Advertisements

  3. BLowry

    Brian S Guest

    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
     
    Brian S, Mar 8, 2010
    #3
  4. BLowry

    BLowry Guest

    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!!!!
     
    BLowry, Mar 12, 2010
    #4
  5. BLowry

    Debra Hill Guest

    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
     
    Debra Hill, Apr 14, 2010
    #5
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.