Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Word to Access (XP)

    Is there any reasonable way to move data stored in Word to Access? A city's forms, such as purchase requisitions, are in Word - based tables. One department wants to have its requisitions tracked in Access, but all that data is stored in Word documents. I'm trying to avoid re-keying existing data. Thoughts?
    Thanks

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word to Access (XP)

    One option would be to copy your table in Word, then paste it into Excel (the table should be reproduced quite nicely in Excel), and then import from or link to this Excel workbook in Access. Depending on the layout of your table(s), you may have to mess with them a little in Excel before importing into Access (e.g., Access expects the field names in the first row and every other row will be treated as records in the Access table), but this should allow you to avoid re-keying the data.

    Holler if you need more detailed help.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Word to Access (XP)

    You are right! It does take some fiddling, but I think I can make it work. Thanks.

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

    Re: Word to Access (XP)

    Another option is to use Automation to extract data from Word directly into Access. Bryan Carbonelle has some samples posted on his website - http://www3.sympatico.ca/carbonnb/bryan/utilities.html.
    Wendell

Posting Permissions

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