Originally posted by jumbleview minimal focus distance 139 mm (measured from the sensor plane)
And 117mm of that is the camera and lens, leaving you only about 21mm of working room off the end of the lens,
being as you don't need 1:1 for either 35mm or any format of 120 film to copy onto APSc, any of theses lenses should work,
myself I always like to use the longest lens I can for any kind of copy work. It's easier to work, and you don't get in your own way as much.
You say you have an A100/4 macro, but are having issues with it. If that is in good shape, it should be good for this task, what issues are you having with it?