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

Can you Use Your data only and not mappoints

This is a discussion on Can you Use Your data only and not mappoints within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a database and i just want my selections to show up. i only want to see my selections ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Can you Use Your data only and not mappoints

    I have a database and i just want my selections to show up. i only want to see my selections not the rest of the world, so if i have five address i only want then to show up. And if i have 3 of same category how can all three ballons show up?

  2. #2
    jia_1980 is offline Junior Member White Belt
    Join Date
    Jan 2003
    Posts
    6
    Hi, there:
    Can you tell me what kind of database you are using? If it is SQL server, you can create a VIEW to store your selection, but for others, I am not very familiar with, I think you can create a temp table; after that, create a .UDL file. MAPPOINT can connect the database by the UDL file.

    Hoping this is helpful.
    Good luck.

  3. #3
    petenyce103 is offline Junior Member White Belt
    Join Date
    Jun 2003
    Posts
    3

    Im using excel

    yes im using excel and not sql. For example im two text boxes one Profession and other zip code and when hit seacrh i just want it to show the professions in that area code. and have them all to show. I dont need any other data. So what options do i have? And what is the best route to use?
    Thanks Pete

  4. #4
    jia_1980 is offline Junior Member White Belt
    Join Date
    Jan 2003
    Posts
    6
    Hi, Pete:
    I am a little confusing about your purpose. Are you trying to create a windows-base application and it can search your EXCEL table by ZIPcode, is it correct? :) In this case, you can read the following article, it has some information about "Extract Information from Excel Sheet with DAO". http://support.microsoft.com/default...NoWebContent=1. If you are using VB and ADODB database engineer, the only thing you need is changing the DAO to ADODB.

    Good Luck.

    Jia

  5. #5
    petenyce103 is offline Junior Member White Belt
    Join Date
    Jun 2003
    Posts
    3

    using two feilds

    well im into health care and if i have a text box called specialty and a text box called zip code. When the user types in specialty i want all the specialties in that zip code to show. Im using excel and i will ahve a database. so if the user types in bone specialist with a zip code of 11757 all the bone specialist in that area code show up. How should i do this?
    thank you

  6. #6
    bigRahn is offline Member Yellow Belt
    Join Date
    Oct 2002
    Posts
    46
    I've not played with connecting Excel to MapPoint.

    Once you have a DB though, it's pretty easy.
    Create a query on the fly when the user enters their selection. (i.e. bone specialist, 98111).
    Use a query similar to:
    SELECT Name, Address, Phone FROM MySpecialists
    WHERE specialtycode = '<insert user selection>" AND zipcode = '<insert user selection';

    This will return the recordset with your information.
    then just loop through the records and put them on your map.

    As Jia mentioned, you can probably use DAO to link directly with Excel, so this same method will work.

    As far as "not seeing the rest of the world", you'll need to put up with some of that...you can't turn off the whole map.
    However, you can set your defaults to not show the internal points of interest.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Capture mappoints close event
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-29-2004, 05:19 AM
  2. Export MapPoints Direction to GPS File. HELP
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-20-2003, 02:09 AM
  3. Is it possible to export MapPoints' nearby places ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-15-2002, 09:14 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