Excel file export from Access table [OLE Object]

[Blasphemer]

Hi,

I have a table where I have an excel file stored as an OLE object and I wish to export it using VBA. I search MSDN and all i can find is BLOB ( http://support.microsoft.com/kb/194975 ), this seems to work well till its text files but doesnt work on excel file. The file format messes up. Can someone suggest me what can be done regarding this, is there another way of exporting OLE objects. Or maybe someone call look at this code and let me know how it can be tweaked to export for exporting excel file.

[Oorang]

Hello,
I ran into that issue too. If you compare an original file to a file saved in OLE at the byte level you will find the OLE file has been reformatted. Unfortunatly I do not know how to manually convert between the formats. However I have heard (not tested) that lebans has solved this issue. Try:http://www.lebans.com/oletodisk.htm

[Blasphemer]

This actually got solved. There is a put into BLOB function and take out of blob. To do this you have to put the file into the table using the blob function and then if you take it out it works.

Thanks:)