OLE DB Provider and Excel
 

I am trying to use the OLE DB Provider for Jet 4.0 in .NET 2.0 to INSERT a
row of data into an Excel speadsheet. The problem I encounter is that there
is one column (the [Description] column) that I need to INSERT a lot of data
into, but I keep getting a "field is too small" error from the Jet engine.

Is this an Excel limitation, a Jet limitation, or what? Is there any way for
me to tweak the "field," which is actually a column in this case, so that I
can get more data into it using the OLE DB provider? Thanks for any help.

OLE DB Provider and Excel
 

Post the code so that we can try it.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"David Mullins" wrote in message
...
I am trying to use the OLE DB Provider for Jet 4.0 in .NET 2.0 to INSERT a
row of data into an Excel speadsheet. The problem I encounter is that
there
is one column (the [Description] column) that I need to INSERT a lot of
data
into, but I keep getting a "field is too small" error from the Jet engine.

Is this an Excel limitation, a Jet limitation, or what? Is there any way
for
me to tweak the "field," which is actually a column in this case, so that
I
can get more data into it using the OLE DB provider? Thanks for any help.