If the drive, after plugging it into a functioning USB port says that you need to reformat it, that is an indication that the drive is either dead/failing or that the port you're working off of is lacking power.
Have you tried running that drive on another system? If the External HDD is outside of warranty, you can disassemble it and connect it to an desktop, internally.
Moved thread from Windows 7 to Storage.