0
Reply

Open Excel file stored in access Database

Shaurya Rastogi

Shaurya Rastogi

Feb 8 2007 9:37 AM
1.8k

I need to open an Excel file that has been stored in the Access Database using the insert Object functionality of MSAccess manually.

What i am aware of is that i cant just read the field containing the Excel File into a Byte Array and pass it to the Excel object in C#,as the file is wrapped in the OLE Wrapper used by Access while inserting the file in database.

I have tried locating the Header of Excel file from the byte array and read the file from there on but it is not working.

Can some one please tell me as to how i can open the Excel File.