odd behavior with ADO.NET

[Techno]

odd. just odd.

we have an excel spreadsheet which has around 1800 rows of data.
we then import this into SQL but we do some analysing and what not in the application.

Now, its using OleDb to connect and get the data. thats fine however we found that half way through, for some of the records (this is when we are reading ALL the records), it truncates part of the data!

if we do this on a new spreadsheet with very few rows, its all fine but when we do it on a large excel spreadsheet, the problem is there.

any ideas why it would truncate part of the data? (no exceptions are occuring as its a select statement... SELECT * FROM [SheetName$])

[riteshjain1982]

you can give a try to MS KB

[Techno]

Thanks. Thought I had fixed it but apperently not.... still the same issue