Excel And Database Datatype Conflict

Hello,

For
a couple of weeks i am struggling with an excel import and export
application to sqlserver as i have to do it through an external
application and not through the Export Import Utility in sql server.

My most recent problem is:
The understanding of field values by sql server and excel.

1. I need to import into a table whose fields are varchar type.
2. I have to use as datasource- an Excel sheet(.xls file).
3. Some fields in excel contain numbers (Length up to 10 or
more digits).
4. For this I first format the cells'(in Excel file) datatype
into "Text".
5. Even then after importing into a table(say tblTemp) whose
schema/structure, is

CREATE TABLE [tblTemp] (
[rowId] int IDENTITY(1,1),
[Account Number] varchar(30) not null ,
[Mobile Number] varchar(30) null,
[Name] varchar(100) null
)
, and to import into this table im using select into query
with datasource as the excel file(Data Source=ExcelFile.xls),

the table fields show exponential values(may be float
datatype).

Shall
any one suggest me how shall i get values from excel sheet with
datatype varchar and import into the above said table as varchar values
(with out any exponential types).