SQL Server 2005: Importing from Excel error

I found this blog post the other day during another search...interesting thing is I ran into this exact issue 6 months ago and was not able to figure out the problem - too bad i did not see this sooner.