Help importing data into Excel/Access

Discussion in 'Archived Threads 2001-2004' started by Brett_H, Jun 10, 2002.

  1. Brett_H

    Brett_H Second Unit

    Joined:
    Oct 3, 2001
    Messages:
    341
    Likes Received:
    0
    All,

    I've been tasked by my fiancee with creating a simple spreadsheet to track our shower invites, received gifts (for the purpose of sending thank-you's), wedding invites, RSVP's, etc. Here's the rub: I've got the invite list in a text document in the following format:
    Mr. & Mrs. John Smith
    123 Main St.
    Anytown, USA 12345
    (Jane)
     
  2. Ted Lee

    Ted Lee Lead Actor

    Joined:
    May 8, 2001
    Messages:
    8,390
    Likes Received:
    0
    first thing i'd do is go to the following website and post this question:
    http://www.mrexcel.com/board/index.php
    barring that, i think you may have to do a little legwork first.
    when you say a text file, i'm assuming a straightforward text file, no special formatting?
    if so, you can use word to do a find & replace function. i'd find all carriage returns and replace with a tab marker. you'll still have to do some cleanup at the end - finding the end of the data and putting a "legit" carriage return manually, but once you have clean data it should be relatively easy to import into excel.
    i'll bet there's a totally easy method, but i just don't know it...
     
  3. Brett_H

    Brett_H Second Unit

    Joined:
    Oct 3, 2001
    Messages:
    341
    Likes Received:
    0
    Ted,

    Thanks for the tip! I was able to use Word to convert all the carriage returns to tabs, then put the carriage returns back in at the end of each record (funny thing, Word doesn't call them "carriage returns" in the replace screen, they call them "paragraph marks" or something to that effect). Excel was then able to import all the records without a problem!

    You rock.

    -Brett.
     
  4. Ted Lee

    Ted Lee Lead Actor

    Joined:
    May 8, 2001
    Messages:
    8,390
    Likes Received:
    0
    sweet...glad it worked! [​IMG]
     

Share This Page