2 Replies Latest reply: Oct 17, 2013 1:29 AM by Jeremiah Lee RSS

    Error Loading Table

    Jeremiah Lee

      Hello Everyone,
      I got an error when loading tables from my exel file. The error is "Cannot locate table in BIFF file.."

      I export the Budget.xls file from a oracle discoverer tool to my C:\Cars\. Strangely the error is gone when i manually save the budget.xls file once it is exported in my PC.Very puzzling. PLease kindly advise. Thanks!

       

      Below is my script:

       

      Load A,

      B,
      C,

      D

      FROM
      [C:\Cars\Budget.xls]

      (biff. embedded labels, table is Headline$);

       

      Load A,

      B,
      X,,

      Z

      FROM
      [C:\Cars\Budget.xls]

      (biff. embedded labels, table is Trades$);