You will have to forgive me guys - I am at work, and strangely enough I can't post at MSDN (They have particular scripts blocked. Go figure). Anyway, a coworker and I have run across a very bizarre problem. We are attempting to read a spreadsheet using an OleDBDataReader and an OleDbConnection. We can read in most things fine from the spreadsheet - it opens up fine, and we are able to get data from it. The odd thing is though, is that we aren't able to read in more than 255 characters from a single cell. Here is the kicker though - the coworker of mine sent it to another employee, and he was able to run it fine and able to read in much more than 255 characters from a single cell. We tried running the same exe on several different machines, with a few different users, and no luck. There is no difference in OS, .Net framework, or the exe, yet it is giving different results. Anyone have a clue what might be going wrong here? I haven't seen anything on MSDN about there being a 255 character limit anywhere.... [looksaround]

As far as I know, its Office 2000. I will hit up that link Michalson, and post some code as soon as I can.

EDIT: Michalson, you were spot on! We changed the registry value and it worked like a charm. I never would have thought that something like that was causing the problem.

Thanks a bunch you two!

[Edited by - Moe on May 4, 2007 9:41:06 AM]