I too use a Sony 3.2Mpel camera of a "certain age".
I have never managed picks of the quality that others here put up. But that's OK, 'cause my painting doesn't quite stand up to the scrutiny of such excellent photos. If my painting is just "adequate", then maybe my photography should be so too.
Anyways, here is what I have found.
1 ) Good lighting. Lots of light. Not direct sunlight, though. Bright reflections off the side of a house on a sunny day, or two or three lamps should do.
2 ) A very steady camera. For me this was one of the biggest issues. The older Sonys have relatively slow sensors = long exposure times. Particularly true in lower light levels. You have GOT to stabilize the camera. I bought a little table-top tripod to help me out. But I don't often use it as a tripod. More often as a mono-pod (ie: all legs folded together) at some angle diagonally or sideways off of a stack of boxes or books ... whatever it takes to get me to the right height, but to have me braced when I actually take the picture.
3 ) Don't get close. Don't even try. 2 feet (60cm) away seems to be about best. No zoom. Nada. Take your picture from a reasonable distance. To get that "close up" that you want, edit your picture down by leaving it at full resolution and cropping all the extraneous stuff out. You want about 640x480 for a forum posting, but your original will be about 3X as big, in each dimension, as that. So you can cut it down to about 1/3 as wide, 1/3 as high, and get rid of 8/9ths of the original picture. Winds up looking reasonably tight.
4 ) Focus. Hmmm. Here its a bit of a trick. My Sony, and yours, I expect, will want to focus on the ground the tank is sitting on (whatever the surface is). What you want to do is point your camera at the tank, push your button to the half-push "auto-focus" stop, and wait for the little green box to form on your viewfinder. Then, HOLDING the button to retain that focus, you want to BACK OFF of your model by about an inch or so. Then finish pushing the button to take the picture. This is why I wind up using my tripod as a mono-pod. I can pivot it about an inch, and still remain braced.

Here is an example. Notice how only one of the howitzers is actually in focus. That tells you how limited your focal depth really is ... only one can be in focus at a time, because if its an inch off either way, its out of focus!
And note that at full resolution, the original picture was 3X larger in each direction! No zooming, no re-sizing though. Just cropping (cutting away the extra), to get it down to this size.
Then, if/as you get something that's even close, POST IT UP! We'll all appreciate it, and you'll appreciate how we laugh and mock you. (No, we won't actually do that! We'd all love to make suggestions on how you might improve your work, whether your painting or your photography. We'll keep all of our snickering and mocking private!)
