The fact that it shows with a drive letter is good news, means the drive is probably physically OK
Bad news is the file structure is corrupt
first try check disk on it
chkdsk /f /r x:
in the search box where x is the drive letter of the usb connected drive.