Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 4 of 4

Field Format issues with import from Excel

This is a discussion on Field Format issues with import from Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi there, I have a problem importing data from Excel. Apparently MapPoint (Europe 2002) treats the data as non-numeric or ...

  1. #1
    Verh0ef is offline Junior Member White Belt
    Join Date
    Dec 2002
    Posts
    9

    Field Format issues with import from Excel

    Hi there,

    I have a problem importing data from Excel.

    Apparently MapPoint (Europe 2002) treats the data as non-numeric or single-value, since `Map Types' Pie Chart - Series Column Chart are greyed out, as well as all of the 'Combine Data by' options except -Count-.

    Oddly, the -same- data imported from an Access database works fine, as well as expoerted to a .csv file and -then- imported in MapPoint.

    I reckon it must have something to do with the Cell-formatting in the Excel file (tried Number and Text), but both did not work.

    Anyone?

    Regards
    Pieter-Joost Verhoef
    MarketPoint.nl
    MapPoint Solution Provider

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    It's hard to say without the spreadsheet except suggest a work-around as you are doing..
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Verh0ef is offline Junior Member White Belt
    Join Date
    Dec 2002
    Posts
    9

    Excel sheet

    I'd love to send the sheets, but can't attach it here...

    pj

  4. #4
    Verh0ef is offline Junior Member White Belt
    Join Date
    Dec 2002
    Posts
    9

    Solved!

    This problem with importing data from Excel seems to be coming from the Excel - MapPoint interface.

    In my Excel sheet, the 1st row are the field identifiers (City, Address 1, etc), the 2nd row (which is hidden) contains the Data Type identifier, that a small "Input Aid" VBA app I wrote, uses for field validation (e.g. when a data type is set to ###, the app expects a numerical value). When I remove this row, the import process works as smooth as a baby's bottom. The process seemed to have "hung" on this 2nd row, when importing from Excel.

    Judging by the effect, the Excel - MapPoint interface probably expects something from the 1st row of data (usually the 2nd row in a sheet) when interpreting data fields. This would imply that MapPoint does not only look at field identifiers, but also at the actual data itself before importing addresses from Excel.

    Emphasizing the probability of this, is the fact that an import from a .CSV text file, holding -exactly- the same data, works perfect. This Text - MapPoint interface probably only works with the field identifiers and does not expect anything else in the rows after that (it simply 'disregards' the row with the Data Type identifiers).

    1 mistery solved and another in its place. Anyway, this discussion might help the next bloke looking for answers. :lol:

    Regards
    Pieter-Joost

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. What it is the command to export data in excel format ?
    By Elbarto in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-15-2006, 04:38 AM
  2. Import data format question
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-30-2004, 09:21 PM
  3. Import on Excel
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-01-2003, 12:48 PM
  4. Import then Map by Date field
    By Mossoft in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-01-2003, 11:38 AM
  5. Import Map from ESRI format to map point
    By ranonah in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-08-2002, 05:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25