Go4Expert (http://www.go4expert.com/)
-   C# (http://www.go4expert.com/forums/c-sharp/)
-   -   Open Excel File Stored in Access Database (http://www.go4expert.com/forums/excel-file-stored-access-database-t2926/)

shaurya.rastogi 9Feb2007 12:10

Open Excel File Stored in Access Database
need to open an Excel file that has been stored in the Access Database using the insert Object functionality of MS Access 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.

while (true)
if (0xE11AB1A1E011CFD0 == BitConverter.ToUInt64(byStream, i))
output.Write(byStream, i, byStream.Length - i-1);

byStream is a byte array into which i have read the Excel file from Database.
I am locating the Excel file header in the byte stream and am writing the byte array to a file from that location.But on opening the written file it dosent work.
Similar approach had worked in case of Images but now in this case.

Can some one please tell me as to how i can open the Excel File.
Can I use Interop.Access object to achieve the goal??

All times are GMT +5.5. The time now is 21:13.