Resistance of a cable/wire is given by the formula R = <rho> * L / A where rho is the resistivity of the material, L = length, and A is the cross-sectional area.

It's a pretty straight forward formula. To lower the resistance, you either decrease the numerator (but a zero length wire is pretty useless) or increase the denominator (a huge-ass not even necessarily infinite, but just a conductor the cross-sectional area of say, the Pentagon, is technically possible but utterly pointless unless you're transmitting electricity cross-continent or whatever.

However, the resistivity of a conductor is its inherent property and so if there were a way to get a material whose resistivity was zero. Then you could transmit huge-ass amounts of energy over hair-strand thin wires because since <rho> is zero, you can play with other parameters in that formula without any fear. Hmm... (hint hint)

The material you need is: http://en.wikipedia.org/wiki/Room-temperature_superconductor

the search continues...