I'm using a 4mp digital camera (Canon Powershot A80) that I love. It has a macro mode that helps sharpen focus as I get in closer though I think if I try to get closer than about 3-5 inches, it's really hard to keep things in focus. Most of these shots are taken at highest resolution from a short distance away (6 to 12 inches?) and then cropped and resized as needed in Photoshop. So what looks like an extreme close-up shot might really be just a cropping to a very small part of a much larger picture. I usually have to throw out a bunch of shots for being blurry due to my hands not being steady enough. I think a tripod would help a lot in these tabletop shots.