I recommend this article on coin photography:
http://www.sigma-2.com/camerajim/cjgcoins.htm
I was especially impressed by the axial lighting technique, and this is what I used to make my photos. Here's an example result:
Source: my website
Now, this was shot with a compact camera (Lumix LX5). It has a wide-angle lens which is fantastic for landsapes, but was rather problematic for shooting macro from far enough to avoid reflections. The setup was constructed from a chair, old lamp, piece of glass taken from a shelve, sheet of paper, stack of books, black t-shirt and old tripod

So you don't really need expensive pro cameras and equipment to do decent photos.
Additionally, the photo above was shot with 3 different exposures and combined using HDR software. This greatly improves contrast and brings up fine details.
And lighting is extremely important, I found that 40W white halogen bulb worked best for me, but it broke and I had to use normal bulb.
BTW, this is my first post here, so I'll use this opportunity to say hi: "Hi everyone"
