Problem in loading excel data to SQL Server

While uploading the data from excel sometimes, data wont get populated into sql. Even, we have followed proper steps to upload the data, the data wont get populated. Why??

Reason:
Its because, sometimes the data in the column may be character or Alpha numeric and SSIS will design its package by considering the column as Integer. In this case, if there is any varchar value,

I have explained excels and SSIS basic characteristics in my another post,

http://venkattechnicalblog.blogspot.com/2008/09/excel-column-is-greater-than-255-in.html

The values wont get inserted into the table. In that case, There are two options to resolve this problem,

1. Option1 : Its tricky one, just copy the varchar related row to the top (may be as 1 row).Now try to create your package using import/export wizard.

2. Option 2: Append a Single quotes(') to the front of all the data and after migration, update the column using an update query like,

update tablename set column1=substring(column1,2,leng(column1))

Happy Learning!!!
Regards,
Venkatesan Prabu .J