MapInfo Pro

Expand all | Collapse all

Format for Excel Files

  • 1.  Format for Excel Files

    Posted 19 days ago
    In my previous version (15), an "imported" Excel file would mostly match with the field formats to those saved in Excel.  The new version coverts all numeric "float" fields to character.  As most fields are like this, is there some way to maintain the formatting (and I have dealt with previous problems using particular Excel formats but I am using "general" here with no designated digits but also doesn't work with "numeric" at 2 digits).?

    ------------------------------
    Rex Edwards
    CAMPBELL AVIATION GROUP
    Alexandria VA
    ------------------------------


  • 2.  RE: Format for Excel Files

    Posted 19 days ago
    Hi Rex

    Yeah, I also recently noticed this and raised this issue with our tech support.
    I'll keep you posted on what we find out.

    PS: Have you tried using the "old" XLS format? Does that work better?

    ------------------------------
    Peter Horsbøll Møller
    Distinguished Engineer
    Pitney Bowes Software & Data
    ------------------------------



  • 3.  RE: Format for Excel Files

    Posted 19 days ago
    Using the 97-2003 format works just fine.  Thanks

    ------------------------------
    Rex Edwards
    CAMPBELL AVIATION GROUP
    Alexandria VA
    ------------------------------



  • 4.  RE: Format for Excel Files

    Pitney Bowes
    Posted 19 days ago
    Hi Rex.
    I entered the issue into our system.  Need to see if it is a change in the MS Access DB engine that MIPro uses to open the newer XLSX format, to see if it could be returning a different type than MIPro expected.
    Opening as an  older XLS  (which is handled by MIPro internal functions for XLS format) or exporting to CSV in Excel then opening in MIPro seems to work fine.

    Regards,
    -Bill

    ------------------------------
    Bill Wemple
    Principal QA Engineer
    Pitney Bowes
    Troy, NY
    ------------------------------