Import Excel Sheet to MSSQL2005

I have a problem importing an excel sheet to MSSQL2005.

I use oledbadapter to import the excel sheet. The problem is that some fields which are numbers disappear when I fill the datatable.

Solution:
Use the IMEX=1 in the connectionstring.
Also make sure that the format of the column is "General" as exponential number will be used if the format is "Text".