Import *everything* as TEXT and fix it later.
Import *everything* as TEXT and fix it later.
I've tried all the suggestions here but still receive that frustrating 'search key' error. Excel-2010 file is 36mb, about 500,000 rows. I'm stumped. Any other ideas. Thanks.