Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • rich hamilton 117 posts 136 karma points
    Oct 11, 2012 @ 11:38
    rich hamilton
    0

    Error validating the Data source: Wrong Local header signature: 0xE011CFD0

    I am getting this error whentrying to import from an excel file

    not sure where to start.

     

    I have removed all suspect characters and spaces in the header line in the import.

    What else could be causing it?

  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Oct 11, 2012 @ 11:46
    Richard Soeteman
    0

    Hi Rich,

    Can you open the file in Excel? What version of Excel are you using?

    Thanks,

    Richard

  • rich hamilton 117 posts 136 karma points
    Oct 11, 2012 @ 12:35
    rich hamilton
    0

    The Excel file opens ok.

    I then saved it as 97 - 2003

    It has frozen panes

    When I saved it as CSV I could start the import

  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Oct 11, 2012 @ 12:37
    Richard Soeteman
    0

    What are frozen panes?

  • rich hamilton 117 posts 136 karma points
    Oct 11, 2012 @ 12:38
    rich hamilton
    0

    just set so when you scroll the top row stays in view

  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Oct 11, 2012 @ 12:46
    Richard Soeteman
    0

    Maybe the Excel component doesn't support that. If you upload a plain normal excel file, is that working?

  • rich hamilton 117 posts 136 karma points
    Oct 12, 2012 @ 13:08
    rich hamilton
    0

    ok, it seems to be working ok now - Thanks.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies