Error exporting data

[Guest]

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?

 

[Tom Ogilvy]

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/06/external_data_m.html