• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

Keeping track changes?

G

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!
 
Top