none
How to copy a MS Word table into an MS Access table? RRS feed

  • Question

  • I have a large MS Word document with 8 columns and about 300 rows. Some of the columns contain one or more screen images. These would need to be either embedded or become a hyperlink to a separate file.I'm using Access 2010.

    I's like to convert this document to an MS Access table and have the data from each column become a field in the MS Access table.

    Due to extreme time constraints on the project I'm involved in, I don't have time to reinvent the wheel myself. Has anyone done this and knows how?

    Saturday, December 2, 2017 10:04 PM

All replies

  • There is no built-in way to do that, especially not with the images.

    One idea is to save the Word document to another format, maybe CSV or XML, but I am concerned about the images. Maybe they could be handled manually - 300 records is not too many.

    The other is to go after the data with Automation, along the lines of https://msdn.microsoft.com/en-us/library/aa537149(v=office.11).aspx#officewordautomatingtablesdata_extractingdatafromatable


    -Tom. Microsoft Access MVP

    Saturday, December 2, 2017 10:41 PM
  • You can use Word automation to loop through the table rows and extract the data and save the images using stdole.SavePicture

    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Sunday, December 3, 2017 1:29 AM
  • Hello,

    What's the current state of your issue? Did you try the suggestion Tom provides? Could it work?

    Please tell us the issue's state and if you have any other solution, I would suggest you share it and mark it as answer to help other developers use this forum efficiently.

    Thanks for understanding

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Tuesday, December 5, 2017 5:46 AM