Thanks for all your help. What I'm trying to do is move
some data stored as an OLE object from access to excel in
the hope that I'll be able to view it as numerical values
which is what I think it is. The data comes directly from
a machine which measures the height of water in 48
separate glasses. At the moment all I see is "long binary
data" in the field dbf_messdaten.

Dave

-----Original Message-----
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;194975
HOWTO: Read and Write BLOBs Using GetChunk and
AppendChunk

--
Regards,
Tom Ogilvy


Tom Ogilvy wrote in message
...
GetChunk is for working with BLOBs.

I suspect he is trying to put a picture in the label.

--
Regards,
Tom Ogilvy

merjet wrote in message
news:BUK4b.246927$Oz4.65734@rwcrnsc54...
It's not clear what you are trying to do he
varVariable = rstLngBinDat!dbf_MessDaten.GetChunk
(0, conChunksize)

Is dbf_MessDaten the name of a field? If so, then
dropping ".GetChunk .
.."
should assign to varVariable the value of that field
for the first
record
in
the
table. I can't fathom what ".GetChunk . ." could be
or your intent using
it.

HTH,
Merjet






.