OK, I think I've discovered why my data wasn't importing. According to this post: http://www.dailydoseofexcel.com/arch...ed-data-types/
It's because my column of data had mixed data types in it. I had a text heading and dates underneath it. I'm assuming this is my problem. Still don't know how to solve it but at least I know.