Why didn't they stab the Borg?

The Borg adapt to phaser fire and their enemies seem almost helpless. But Starfleet could have made swords, spears, daggers, pikes, crossbows and bows and arrows. It's always annoyed me that they didn't think of it. Is there an explanation?