Too many characters for Jet 4.0

Hi all,

I'm trying to insert a field into an Excel 2000 file, using the MS Jet OLE DB 4.0 driver. If the text I'm trying to insert is grater than 255 characters, I get this error:

"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

I must allow for the insertion of more than 255 chars. I know it's not an Excel problem because Excel can hold all the data if I just copy and paste it, but when the data comes thru a VB program using that driver, the driver becomes the bottleneck.

Is there a workaround or update for this, or another driver I could use?

Thanks in advance.