Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Word --> Access (XP)

    I have a number of Word files containing testbank questions of the form:

    15. The amount by which an objective function coefficient would have to improve before it would be possible for the corresponding variable to assume a positive value in the optimal solution is called the
    a. reduced cost.
    b. relevant cost.
    c. sunk cost.
    d. dual price.
    ANSWER: a
    TOPIC: Reduced cost

    That I would like to import to an Access database. Right now, I'm manually cutting and pasting, one field at a time. Is there an easier way?

    Ronny
    Ronny Richardson

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word --> Access (XP)

    Does the Word document consist of a table (or tables)?

    What is the structure of the table(s) you want to import to?

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Word --> Access (XP)

    It depends a good deal on the way your Word documents are structured. It would be possible to use automation to do the deed for you if each question were formatted in a specific way, but if there is significant variation, it becomes a major challenge. I would actually look at restructureing the Word docs into a delimited text format and then importing them into Access. But even that's a pain if each question is a separate document. Another complication is the number of possible answers - if it varies, the problem is more complex. In the long run you may find that your current cut and pase approach is the quickest. On the other hand if you have 10,000 questions, it would be worth spending quite a few hours to automate the process. I'm afraid this isn't terribly helpful, but perhaps it will give you some guidance.
    Wendell

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Word --> Access (XP)

    It's the worst possible scenario. Textbook publishers lump all the questions from one chapter together so the true/false all have two answers, the multiple choice have between three and five and then there are the short answer and essay questions where the student is not presented with an answer at all. To make matters worse, the documents are highly formatted (tabs, numbers, some character formatting).

    I was hoping that some utility or shortcut would come to mind. Otherwise, I suspect you are right and my copy-and-paste routine is likely the best approach. I do this one chapter at-a-time as I need the questions so I never spend more than an hour or two at any one sitting and I'm not much of an Access expert so any sort of programmng is out of the question.

    Thanks
    Ronny
    Ronny Richardson

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word --> Access (XP)

    I programming is not feasible, your current approach is the best you can do...

Posting Permissions

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