How to define Field object for GetChunk method

[Doogster]

Hi folks

I'm attempting to extract some text from a BLOB file in Excel using VBA using the GetChunk method.

According to the Microsoft help file, GetChunk is used as follows:

Set variable = recordset ! field.GetChunk (offset, numbytes)

I understand all of this except for the "recordset ! field." part. What exactly does it mean?

Here's what I've come up with:

Sub RostersTEST()
Dim Extract As Variant
Extract = xxx.GetChunk(2, 16)
End Sub

Note that this is stripped down to demonstrate what I am trying to do. The "xxx" is where I am confused. How exactly do I declare that recordset/field value as a variable (if indeed it needs to be declared)? I've tried declaring it as a Field, but my VBA won't recognise Field as a data type (Access 2003).

I am seriously confused by this. Anyone who can assist will have my eternal gratitude!

Cheers. Doogster