CC transfer & major change??? HELP!

I’m currently a freshman at my local county college. I am a business administration major. This semester has made me realize I no longer want to be in the business field. I want to achieve a BSN (bachelor of science in nursing). I graduated high school with a terrible GPA. Since I got a C+ in my high school Chem class I won’t be accepted into my CC nursing program and even I was I would have to stay in it and graduate there which is not what I want to do. I wondering if I should take classes that go along with a nursing degree and then transfer as a junior to a university. Can I transfer into a nursing program as a junior without being in a nursing program in my CC? Also should I change my major to allied health or something along those lines because I won’t be able to major in nursing? Please help. Thank you in advance.