SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    May 2004
    Location
    california
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need help convert Txt file to Access!!!!!!!

    Hi There,

    I have this text files (URL http://www.orangecountybusiness.org/L.txt ) and wanted to transfer this to my Access database.

    Ask you look at that text file, the first work is the legal term than the definition.

    Can someone please show me how to transfer this over to Access with one field for the key term and the other fields for definition?

    Thanks in advance,
    Linda

  2. #2
    Xbox why have you forsaken me? moospot's Avatar
    Join Date
    Feb 2001
    Location
    Clearwater, FL
    Posts
    3,615
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would put the file in Excel and parse out the first word (or two words) into a separate column so that the term is in one column and the definition is in another. Then you can save the file as a csv file and import it into Access.

  3. #3
    SitePoint Member
    Join Date
    May 2004
    Location
    california
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How do I parse out the first word two words? Do you have instructions on how to do this?

    Thanks,
    Linda

  4. #4
    Xbox why have you forsaken me? moospot's Avatar
    Join Date
    Feb 2001
    Location
    Clearwater, FL
    Posts
    3,615
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You would have to use a function to read the first space after the first word. It wont work on two word terms, but you can go back and edit those manually.

    Let's assume your target cell is A1

    =LEFT(A1, FIND(" ", A1, 1))

    This will extract the first word (before the first space) from the text.

    =RIGHT(A1, LEN(A1) - FIND(" ", A1, 1))

    This will get the rest of the text. Place this in the next cell over. Then you need to copy the two columns you just created, click on Sheet 2 and Click Edit --> Paste Special --> Paste Values. Save the current sheet as a csv file and then you can import it into access.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •