Results 1 to 5 of 5
  1. #1
    jwtasu is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    3

    Create Database from Word Document

    I have a Word document that is nearly identical to the attached MS Word document. I am trying to import the document into records and fields. I'd like to make all of the line items in the index / table of contents be separated as records, i.e.:
    1. Introduction to Mopping the Floor (1 record with a field/value for 1., Introduction, to, Mopping, the, Floor - so 6 fields/values in the record)
    1.1. the mop (1 record with a relationship to the first one by the 1st fields matching "1." and "1." with the 2nd field in this record being the second "1." and then "the" and "mop" being separate fields)



    This would enable me to publish the document with tags enabling searches and such. I would like to be able to create future forms, reports, and web media that would be able to call this document and link it to other data in Access.

    Without going in there and manually adjusting Excel Workbook and then manually adding each table separated by chapter (I guess?) from Excel to Access, I am not sure even where to start?
    Delimitters and such seem a bit ackward for the formatting of the attached word .doc, but it could be my time of separation from good ol' Excel.
    Any input on starting points or conversion tips/software would be great. A script of some sort to help me create my own import means would be awesome too.
    Thanks,
    JT
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,956
    I doubt what you want is possible. I think you have some hours of data entry (with copy/paste) ahead.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jwtasu is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    3
    My knowledgo of product is limited, but what about using Adobe inDesign to get started?

  4. #4
    jwtasu is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    3
    Would it be faster to do data entry straight into tables in Access via copy/paste and typed?

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,956
    I don't know what Adobe in Design is.

    Not only easier but quite possibly the only option.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create new Word document.
    By Bill H in forum Programming
    Replies: 3
    Last Post: 06-12-2012, 06:40 AM
  2. Export report to word document
    By jackyoung2012 in forum Reports
    Replies: 1
    Last Post: 03-16-2012, 11:16 AM
  3. Closing Word Document From Access
    By bburton in forum Programming
    Replies: 2
    Last Post: 04-25-2011, 10:23 AM
  4. Import Word document using VBA
    By degras in forum Import/Export Data
    Replies: 4
    Last Post: 04-12-2011, 02:40 AM
  5. Replies: 0
    Last Post: 06-14-2010, 07:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums