If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keeping track changes?
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! |
Thread Tools | |
Display Modes | |
|
|