My 2p. Upload your 940 CCF from the remote to your computer. Save it. Next, open the recently uploaded CCF and save as a 970 file with different name. Then download to the 970. Simple as that. Make changes as you need to and enjoy.
The 940 likely had less memory than the 970 and going backwards might have caused you issues. Not sure about what you mean by destroyed as I've never seen a remote fail due to CCF being too large.