If only i knew this earlier…

Remember this excel connection string parameter when you’re trying to import data in SSIS and the columns have mixed data types i.e. the column has floats and strings.

You’ll save some hair off the top of your head…