title: The field is too small to accept the amount of data you attempted to add. Has anyone gotten this error from ADO.NET?
body: <p>Updating an Excel file from a dataset seems to work fine. But if I have text that's longer than 255 characters then I get the error above. Has anyone else gotten such an error? How do you fix it? I've been working on this for a couple of hours and I haven't gotten anywhere. I've tried messing with the connection string and changing a registry setting, but no luck.</p>