1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Open Excel File Stored in Access Database

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

  1. shaurya.rastogi

    shaurya.rastogi New Member

    Feb 9, 2007
    Likes Received:
    Trophy Points:
    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