Five years ago, I flunked out of Electrical Engineering school and so have two semesters of F's on an otherwise healthy looking transcript, but my overall GPA was 2.3. Guess what? I got into nursing school my first try!
My ADN program goes by a pre-requisite GPA and a point system. Since that GPA was a 3.5 and all courses in the last 5 years were A's and B's, my points were very competitive.
When I get done with this program, I plan to go to a RN to BSN Program, so I am working my behind off to make sure I keep getting the grades... I think it requires a 3.0, so I really need the A's here in my program.
Find out what schools you are interested in and find out what criteria they use... some of them only use science GPA's, pre-requisite GPA's and some of them use overall GPA's. It varies widely, especially between ADN and BSN programs. Shop around and keep a positive outlook. Of course, it can be done!