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 2 of 2

Excel import data missing S&T 2010

This is a discussion on Excel import data missing S&T 2010 within the MapPoint Desktop Discussion forums, part of the Map Forums category; I just upgraded my S&T 2006 to 2010. Now when I import my work sites (Excel 2007) spreadsheet, it's missing ...

  1. #1
    CableSux is offline Junior Member White Belt
    Join Date
    Mar 2011
    Posts
    2

    Excel import data missing S&T 2010

    I just upgraded my S&T 2006 to 2010. Now when I import my work sites (Excel 2007) spreadsheet, it's missing almost half of the data. My spreadsheet has 8,011 addresses. S&T shows only 3,712 imported. No error messages.

    Has anyone run into this problem? I searched your forum and didn't find anything.
    Attached Images Attached Images

  2. #2
    CableSux is offline Junior Member White Belt
    Join Date
    Mar 2011
    Posts
    2

    Re: Excel import data missing S&T 2010

    I don't know what is causing the problem, but I found a work-around. I get my data from a web site with an Export to Excel link. If I open it (instead of save) and then save it as an xlsx file and try to import it, it imports only 3,712 records. If I save the excel file as a 2003 (xls) file and import it, it imports only 3,712 records. Same thing with S&T2006.

    Now, if I save it from the get-go from the web site as a 2003 Excel file and then import it, all 8000+ records are imported. Sounds like it's an Excel problem.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cannot import Excel in Mappoint 2010
    By jdeast in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 12-02-2010, 11:35 PM
  2. Replies: 0
    Last Post: 04-07-2010, 04:37 AM
  3. MapPoint 2010 Import data problem
    By GaryK in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-10-2009, 06:51 PM
  4. How to import traffic census data from Excel into MapPoint?
    By Sheldon in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-22-2008, 06:17 PM
  5. Error on import data from Excel to mapPoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 01-27-2005, 04:06 PM

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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127