If you can't even see the card, then you can't recover data from it using the common data recovery tools (they address issues like broken file systems and deleted files).
You might try a data recovery company; I believe some are now offering card recovery. Expect the cost to be high though. Hundreds of dollars is common, sometimes even more.