Sign in Register
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?

    Copy Link
  • Richard Soeteman 4046 posts 12899 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

    Copy Link
  • 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

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Oct 11, 2012 @ 12:37
    Richard Soeteman
    0

    What are frozen panes?

    Copy Link
  • 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

    Copy Link
  • Richard Soeteman 4046 posts 12899 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?

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

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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft