See this discussion by Jamie Collins on a problem with mixed data types in a
column when using ADO.

http://www.dicks-blog.com/excel/2004...al_data_m.html

--
Regards
Tom Ogilvy


"dida1981" wrote in message
...
Iam working on a project to export data from excel sheets to SQL2000,
using
ADO.net I load data into dataset then upload it to SQL 2000 tables, any
way
when I view data in datagrid some cells are missing when I look for it in
the
sheet I found this the field holding the fax some cells look like
(3552222)
this field appear and others like (0335552222) doesn't appear and another
field hold No. of employees some Cells look like (70) appear and others
like
(70-80) doesn't appear?