none
Insert Excel Spreadsheet Into Word From Access Database RRS feed

  • Question

  • Hi,

    I have an Access database with Excel spreadsheets (files) linked to a field in each record.

    In Word, I have setup a mail merge which picks up the data from each record and I want to insert the spreadsheet which is linked to each record.

    Word picks up the link for the spreadsheet, but I'd like to display this in a table format.

    http://s3.postimage.org/hk0aqk4zn/Test.jpg

    Is this possible?

    Thanks,
    Vignesh
    Sunday, February 3, 2013 9:53 PM

Answers

  • Hi Vignesh

    If you have the path information, then theoretically the mergefield for this could be nested in a LINK field. How well this works depends, however, on the version of Word you're using. The field code would look something like the following for Word 2007 & later:

    {Link Excel.Sheet.12 "{Mergefield ExcelLink }" }

    Usually, you'd have to have the field codes showing and immediately execute the merge after creating this nested field to keep Word from converting the mergefield at the present record to static text (meaning every record would get the same Excel table).

    For inserting field codes, you must use Ctrl+F9 to insert the { brackets }, you may not simply type them as I've done here.


    Cindy Meister, VSTO/Word MVP, my blog

    Monday, February 4, 2013 9:10 AM
    Moderator