The megapixels don't mean much, its the size of the ccd, the quality of the lens, and some operator skill can help alot.
I've got a 6.3 megapixel SLR, which makes beautifully detailed a3 sized prints.
There is no compact camera out there which will do that, not anywhere near as clear...