If you want more detail you need to have more pixels and you need more "stuff" in focus.
To have more pixels, you need either a new camera or you stitch many photos together.
Ian mentioned Pano using Adobe. I've never used it. I use Hugin. It is free and does amazingly well
http://hugin.sourceforge.net/
http://hugin.sourceforge.net/download/
Here are two pictures I put together with no effort
(using my wife's $200 point and shoot camera. Stitched maybe 7-8 photos)
http://i20.photobucket.com/albums/b248/BeyondGomer/joists.jpg
(very little effort involved here: macro lens on tripod. 12 images)
http://i20.photobucket.com/albums/b248/BeyondGomer/SPSpano-1.jpg
See if you can find the stitching
(hint, you can see it sorta because I didn't crop correctly along the bottom right edge)
To get more stuff in focus, use a smaller aperature (higher F#)
This gets harder because you will have a slower shutter speed. This pretty much will force you into a tripod.
(a lower iso also helps, but it also has the same penalty of slower shutter speed)