Professional Web Applications Themes

>255 into excel? - ASP Database

Hello Im having problems, I need to insert more than 255 chars into an excelcolumn and i get: "Data type mismatch in criteria expression." insert into [Synpunkter$]([Ämne],[Fel/Synpunkt],[Frågeställare],Svar,Datum,Status)values ('VAFocus - ADH','Item cannot be found in the collection corresponding to the requested name or ordinal.Item cannot be found in the collection corresponding to the requested name or ordinal.Item cannot be found in the collection corresponding to the requested name or ordinal.Item cannot be found in the collection corresponding to the requested name or ordinal.Item cannot be found in the collection quested name or ordinal.Item cannot be found in the collection corresponding to ...

  1. #1

    Default >255 into excel?

    Hello

    Im having problems, I need to insert more than 255 chars into an excelcolumn
    and i get:

    "Data type mismatch in criteria expression."

    insert into
    [Synpunkter$]([Ämne],[Fel/Synpunkt],[Frågeställare],Svar,Datum,Status)values
    ('VAFocus - ADH','Item cannot be found in the collection corresponding to
    the requested name or ordinal.Item cannot be found in the collection
    corresponding to the requested name or ordinal.Item cannot be found in the
    collection corresponding to the requested name or ordinal.Item cannot be
    found in the collection corresponding to the requested name or ordinal.Item
    cannot be found in the collection quested name or ordinal.Item cannot be
    found in the collection corresponding to the requested name or ordinal.Item
    cannot be found in the collection corresponding to the requested name or
    ordinal.Item cannot be found in the collection corresponding to the
    requested name or ordinal.Item cannot be found in the collection
    corresponding to the requested name or ordinal.Item cannot be found in the
    collection corresponding to the requested name or ordinal.Item cannot be
    found in the collection corresponding to the requested name or ordinal.Item
    cannot be found in the collection corresponding to the requested name or
    ordinal.','Lasse Edsvik','','2004-08-24','Ej besvarad')


    ive changed the "datatype" for the column to text......... still i get that
    error, works with less than 256 chars........ :(

    what's wrong?

    /Lasse


    Lasse Guest

  2. #2

    Default Re: >255 into excel?

    Are you using ODBC or OLEDB to connect to the spreadsheet?

    Lasse Edsvik wrote: 

    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Guest

  3. #3

    Default Re: >255 into excel?

    Provider=Microsoft.Jet.OLEDB.4.0



    "Bob Barrows [MVP]" <SPAMcom> wrote in message
    news:phx.gbl... [/ref]
    [Synpunkter$]([Ämne],[Fel/Synpunkt],[Frågeställare],Svar,Datum,Status)values 
    >
    > --
    > Microsoft MVP - ASP/ASP.NET
    > Please reply to the newsgroup. This email account is my spam trap so I
    > don't check it very often. If you must reply off-line, then remove the
    > "NO SPAM"
    >
    >[/ref]


    Lasse Guest

  4. #4

    Default Re: >255 into excel?

    "Lasse Edsvik" <com> wrote in message
    news:#phx.gbl... 
    excelcolumn 
    [Synpunkter$]([Ämne],[Fel/Synpunkt],[Frågeställare],Svar,Datum,Status)values 
    ordinal.Item 
    ordinal.Item 
    ordinal.Item 
    that 


    Use a Memo field.


    McKirahan Guest

  5. #5

    Default Re: >255 into excel?

    "Lasse Edsvik" <com> wrote in message
    news:#phx.gbl... 
    excelcolumn 
    [Synpunkter$]([Ämne],[Fel/Synpunkt],[Frågeställare],Svar,Datum,Status)values 
    ordinal.Item 
    ordinal.Item 
    ordinal.Item 
    that 

    Try a Memo field.


    McKirahan Guest

  6. #6

    Default Re: >255 into excel?

    i did that in excel yes, and it dont work......


    "McKirahan" <com> wrote in message
    news:0oFWc.173646$.. 
    > excelcolumn 
    >[/ref]
    [Synpunkter$]([Ämne],[Fel/Synpunkt],[Frågeställare],Svar,Datum,Status)values [/ref]
    to [/ref]
    the 
    > ordinal.Item 
    > ordinal.Item [/ref]
    the 
    > ordinal.Item 
    > that 
    >
    > Try a Memo field.
    >
    >[/ref]


    Lasse Guest

Similar Threads

  1. Excel to SQL DB
    By arjahan in forum Coldfusion Database Access
    Replies: 2
    Last Post: February 27th, 08:13 PM
  2. Place Excel into table with ability to link when native Excel file is updated.
    By Nancy_Bubb@adobeforums.com in forum Adobe Indesign Windows
    Replies: 1
    Last Post: June 23rd, 03:23 PM
  3. Using Excel API in .NET
    By Chris Jackson in forum ASP.NET General
    Replies: 1
    Last Post: August 7th, 03:13 AM
  4. Replies: 1
    Last Post: July 14th, 03:00 PM
  5. Replies: 1
    Last Post: July 14th, 02:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139