1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Open Excel File Stored in Access Database

Discussion in 'C#' started by shaurya.rastogi, Feb 9, 2007.

  1. shaurya.rastogi

    shaurya.rastogi New Member

    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??

Share This Page