>255 into excel?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lasse Edsvik (lasse_at_nospam.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 10:20:59 +0200

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

Relevant Pages

  • get the sql statement
    ... Data type mismatch in criteria expression. ... Protected Sub btnSave_Click(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error 3464 with dCount - some computers only
    ... Error 3464 - Data type mismatch in criteria expression" from this line ... and produces a recordset with 36 records ... this code (and the print in the immediate window) ...
    (microsoft.public.access.formscoding)
  • Re: sort report by year (weird format)
    ... its okay - i get the error "data type mismatch in criteria expression" ... can i use a query?) ... Marshall Barton wrote: ...
    (microsoft.public.access.reports)
  • Re: Update query
    ... > It *should* set the value to NULL if the Allow Zero Length is false. ... Data type mismatch in criteria expression. ... Those are 2 single quotes... ...
    (microsoft.public.access.queries)