I also flunked out of the first college I went to. OK, they asked me not to come back...
I was young and wanted to party more than study.
Now, I'm entering my last semester, and I'm pulling a 3.78 right now. I work, have a family and do a heck of a lot more than I had to do at the other college. It's the motivation. Not only am I paying for this myself, but I'm doing this to improve my family's life.
A lot of schools weed out, but in all honesty, they do it for a good reason. Would you want someone who didn't know the proper technique, action of a drug they were giving you, etc....
Nursing school IS tough, and rightfully so. But, it's not impossible. If you can come in with a 3.7, I wouldn't worry at all. Just put your nose to the books and be prepared. Most people I have seen fail either a) just don't get it or b) are not at the maturity level to accept the responsibility.
Just look out for number one...you....and you'll be fine. Don't listen to the gossip...most of it is garbage anyway. Everyone wants to blame their failing or bad grade on an instructor. These people aren't good for you. They are the ones that set you up to fail.
PS Good luck to you!