Results 1 to 4 of 4
  1. #1
    klott01
    Guest

    Import Word fields into Access

    Is there a way to import MS Word fields into Access or Excel? I have multiple MS Word documents that each have multiple fields that I need to import into either Access or Excel for report genearation. Any ideas?

  2. #2
    New Lounger
    Join Date
    Feb 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Word fields into Access

    Did anyone ever locate a solution to this question? I can't seem to find one in the archives, and I've got a similar situation, only my Word documents to import are not in fields, but rather seperated by double hard returns, each section needs to have its own record in Access.

    Mark

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Word fields into Access

    I've had to import Word documents before but usually from tables in Word. The technique usually involved using the find and replace feature of Word to place some delimiting character between fields and records. Then saving the doc as text and importing into Excel or Access. You might be able to use a similar technique if your docs have a repeating structure of some kind.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Word fields into Access

    You'll find <A target="_blank" HREF=http://www.helenfeddema.com/>Helen Feddema</A> is often a good source of information and sample code for Office interoperability.

Posting Permissions

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