Help needed regarding excel interop
I'm working on an Excel Interop application using C#.
Am using OleDbCommand and INSERT INTO query to insert data from a .Net datatable into an excel sheet.
Am getting following error when I try to insert a field which has more than 255 characters.:
"The field is too small to accept the amount of data you attempted to add.Try inserting or pasting less data."
Any ideas how to fix this????