I use a canon G5 digital rangefinder camera, it has a macro setting. Besides a macro lens you can also find macro filter sets that will do a decent job.

Have fun
Paul