My Little Miss is 8.5 months now and after she bit me on the tit (with one of her already 3 teeth) I decided it's time to wean. So painful to feed the past 3 days!! So yes I'm in the same situation. I'm trying Avent bottles and S26 Gold, she will drink water out of the bottle, but as soon as I give her the one with the milk she pushes it away!
I don't think its the formula as such, like someone said you could probably try 10 different brands all are going to taste different to mummys milk! Not to mention the expense! I'll keep tryin with S26Gold for now cos I think it's the revolt of "I'm not drinking milk from that thing, it's what mummy is for!" And she likes it well enough in her cereal in the mornings.
My first kid was about the same age when I weaned him, funny enough I tried heaps of different kinds of teats & bottles, and he took to the cheapies in the end after some weeks of trying him once or twice a day.
So my suggestion would be persistence (and yes I will pursue my own advice, and let you know if there is any progress in a few weeks). But I am not discounting that babies may not like certain formulas too, always a possibility, so it doesn't hurt to try! Oh yeah & like I did with James (sick of wasting formula) I tried him with water, so he would just get used to drinking from a bottle to begin with and then tried the milk again when I knew he can actually drink from the bottle (eliminating one problem at the time).
Sorry for starting to ramble on now.
Good luck anyway.
Kristina, Mum of James 3yrs & Matilda 14 months