I am loading data from an Excel 2003 spreadsheet into a SQL Server 2000
database using DTS. One of my columns contains account numbers. These
are usually numeric, but sometimes contains letters. The cell
formatting for this column has been set as text, and it's mapped to a
varchar field in SQL server. Usually the numbers go into the database
correctly, but they sometimes end up in scientific notation. This
happens even when the numbers don't appear this way in the spreadsheet.
Any insight that can be provided about why this happens and how to fix
it would be greatly appreciated. This problem has been bothering me
for quite some time, and I have yet to find an answer about what's
going on here.

Mike