This is something I'm really struggling with and haven't found much when I search (maybe I'm not wording too well, or I get too wordy and results are all over the place) I have an excel file that contains an alpha-numeric field. The destination in my database is a varchar(25) Problem is, when I import, any non-numeric field returns a NULL value even though it is a varchar field in the table. I looked at the excel file, and even the top 10 rows or so are alpha and numeric. I will say that the only thing that ends up working for me is if I go into the excel file and manually sort this field descending (putting the alpha cells first). That works, but very impractical if I'll need to do this regularly (for the time being, I have made it NOT NULL so I don't accidentally import without doing the sort)
I understand this is kind of a newbie problem, but I'd love to get my head around it
thank you kindly!