I'm another one that's not too keen on heights. But again there was something about flying which was too strong to resist. Getting airbourn for the first time was a real buzz, but coming in to land I started to get pretty nervous!
It took me about 5 hours to get used to the height. I was convinced I'd never be able to fly solo because I'd be too scared!
But the thrill of flying meant I soon overcame that. I still have the occasional moment when I remember how far away the ground is, but it's more of a thrill than a fear now

I have to say that the best thing for my confidence was spending some time doing aerobatics. I've become so much more relaxed about flying since then it's amazing (a huge thank you again to the person who let me do this, if you're reading!)
Go for it... don't sit on the ground wondering