How can I connect direct TV to a TV that only has a cable connector?

You can buy the leads from eBay etc.. If you have a DVD or Video player, you could always feed it through that instead.