Re: How to write long text into Excel(meet 255 characters limitati



God, thank you very much.

But I have researched for days, and hadn't found any resource or document
said about this limitation in Excel.

Could you tell me where to find it, which document should I see?


"Michael D. Ober" wrote:

> This is a limitation in Excel. You will need to break your string into
> multiple cells.
>
> Mike Ober.
>
> "David Zhu" <DavidZhu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:26446DDE-D126-4EA4-A634-E28238FB1946@xxxxxxxxxxxxxxxx
> > Hi all, I meet 255 characters limitation when insert a string field into
> an
> > excel file.
> > Even though I have tried two method, using command.execute() or using
> > recordset.addnew().
> >
> > the code likes below:
> >
> > var sql = "insert into survey values (?)";
> >
> > var command = Server.CreateObject("ADODB.Command");
> > command.CommandText = sql;
> > command.CommandType = adCmdText;
> > command.CommandTimeout = 15;
> > command.ActiveConnection = conn;
> >
> > var Parm1 = Server.CreateObject("ADODB.Parameter");
> > Parm1.Type = adVarWChar;
> > Parm1.Size = 1000;
> > Parm1.Direction = adParamInput;
> > Parm1.Value = edName;
> > command.Parameters.Append(Parm1);
> >
> > command.Execute();
> >
> > An error "The field is too small to accept the amount of data you
> attempted
> > to add."
> > would allways occur when the length of value large then 255.
> >
> > I really need your help!
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
.



Relevant Pages

  • Re: Large integers in excel 2003 are rounded ?? Is this a BUG ?
    ... Quattro Pro, have the same limitation. ... "IEEE 754", which was created to achieve faster processing by sacrificing ... To do math in Excel on numbers with arbitrarily large numbers of significant ... My Excel add-in xlPrecision 2.0 allows up to 32,767 significant digits. ...
    (microsoft.public.excel.misc)
  • Re: Creating discussions board
    ... I'm aware of the XP limitation. ... I built the pages in Excel and used the "save as web page" ... >is no need to install Office Server Extensions (not even ... >Kristofer Gafvert - IIS MVP ...
    (microsoft.public.inetserver.iis)
  • Re: Max length of column defined in activity in Excel for BAM
    ... of a column in an activity defined using BTS 2006 tool BAM add-in in MS Excel ... This limitation has to be coming from the add-in, ... The maxlength for an nvarchar column insql server 2000 is 4000. ...
    (microsoft.public.biztalk.general)
  • Re: Reading to a 1-D array...Error
    ... Bernie - can you clarify your statement? ... There is no such limitation on a function if it is used as you illustrated ... Limitations of Passing Arrays to Excel Using Automation ... > Function GenMArray() As Variant ...
    (microsoft.public.excel.programming)
  • Re: Excel Process still running
    ... Mike Ober. ... > I'm working on an application that opens an excel workbook, ... and have freed all the object references to the excel application, ...
    (microsoft.public.dotnet.languages.vb)