View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Al Findlay Al Findlay is offline
external usenet poster
 
Posts: 1
Default Printing Excel BLOBS

Hello!

I have an MS Access database which contains a table named 'Sheets'.
Each record has a memo field that contains a BLOB representation of an
Excel sheet.

What I want to do is iterate through each record and print out the
BLOB Excel sheet in Excel.

I know how to retrieve the data from the BLOB and write it to an Excel
file, but I do not have permission to write a temporary file. Is there
any way I can use Excel to print or open an in-memory representation
of the Excel BLOB (maybe via a stream of some sort)?

Thanks,

Al