Yes! Could you access this CF card right now?
If you still cannot access this card for the “nor formatted problem”, I think you should do the following steps to fix your problems.
1. Do not format this CF card. No one could ensure that the formatting process would not make things worse.
2. Do not save new data on this card in case that your inner saved photos and videos would be overwritten.
3. Do not randomly select data recovery software to restore your data. Even though there are plenty of data recovery programs on the market, you could not randomly select one to try. You should make much researching one the internet and then make your decision.
Read more information of data recovery stuff here:
http://geeksdo.com/freeware/data-recovery.html
4. Learn not to save the restored data on this CF card in case of data recovery failure and always remind yourself to back up all your important data on different storage devices.