Importing Excel 2007 (*.xlsb) file with Chart RRS feed

  • Question

  • User-1077115221 posted
    <Hi Friends, I need to read an Excel file (*.xlsb) using oledb. But i need to keep my excel file open to read it without error. If my excel is not open, then i am getting "External table is not in expected format." error. My Excel file contains some charts. If i removed those charts then i can able to read it. I need to read the excel file without opening it. Please help Thanks in Advance, Padma
    Monday, April 4, 2011 1:57 AM


  • User-1946294156 posted

    Try utilizing a technology from Microsoft called Sql Server Integrated Services.  This is should solve your problem.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 20, 2011 7:51 PM