How long until negative association disappears after a bad drinking experience?

Hello, I am quite new to drinking and have only been doing it for about a half a year now. A few weeks ago, I drank a full bottle and a half of white wine and ended up vomiting for the first time in 15 years so I must have really overdid it. Ever since then, even the thought of drinking wine again makes me sick and smelling or having a sip of anything remotely similar like champagne completely ruins my drinking experience and has me checked out for the night. I really like wine, so this is very disappointing for me and I’m wondering how long It typically is before the negative association disappears after a shitty drinking experience, and I can try and consume it normally again. Thanks.