1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Keeping track changes?

Discussion in 'Microsoft Office' started by GirlieNinja, May 4, 2010.

  1. GirlieNinja

    GirlieNinja Flightless Bird

    I am trying to import some spreadsheets (that were originally tables in a
    word doc) into Access 2007. I am able to keep the track changes when copying
    from word to excel, however they dissapear when importing to access (or
    copy/paste into access). The project I'm doing requires that users be able to
    see any changes that have been made to these records, so I need to find a way
    to keep the engrossing when putting it into access. My thought is that I can
    replace strikethroughs with the text in brackets and replace additions with
    the text in angled brackets (or something like that). Even though Access 2007
    supports rich text, it doesn't import track changes (it deletes deletions and
    adds insertions), however if I copy one cell at a time into access it doesn't
    do that. Anyway, I'm getting a bit frustrated.

    I guess what I'm asking if there is a macro I can use that will find and
    replace deletions/insertions? Or does anyone know a way to import them into
    Access without losing them?

    Any help is appreciated.

    Thanks!
     

Share This Page