viewing data in excel

P

probitas

i'm trying to look at the contents of an ole object field which at the
moment displays only "long binary field" in all its cells. i'm storing
the data in a variable using the get chunk method as shown below.

Sub SetDataToVariable()

Dim dbsNozztst As Database
Dim rstLngBinDat As Recordset
Dim varVariable As Variant
Const conChunksize = 32768

'open database "db1.mdb" and recordset "dbt_Pruefbericht"
Set dbsNozztst = OpenDatabase("db1.mdb")
Set rstLngBinDat = dbsNozztst.OpenRecordset("dbt_Pruefbericht")

'use GetChunk method to assign long binary data to a variable
Set varVariable = rstLngBinDat!dbf_MessDaten.GetChunk(0, conChunksize)

'close database and recordset
dbsNozztst.Close
rstLngBinDat.Close

End Sub

problem is i don't know how to get at this variable from excel and even
then not too sure if i'll actually see the data i want. Any help very
much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top