Import locations

Anonymous
09-10-2002, 02:20 PM
I have 300 locations to map in Canada. I tried to import an Excel file with the name, the address (ex: 453 King Street), the city and the province. I can't get Mappoint to recognize my address, so everytime it map the locations by the city. Is there a way to make this work, if not I will have to add the location one by one with the find option.

Thanks

John Meyer
09-10-2002, 02:52 PM
Could you post a sample (a row or two) of your excel file?

Anonymous
09-10-2002, 03:36 PM
Name____Address____________City___________Province ______Country
9891318__500 Papineau_______Montreal_______Quebec________Canada
9894213__180 Tremblay_______Boucherville____Quebec________Canad a

I found out that if I choose USA for the country the matching option is set to street address but if it's CANADA the matching option is city. So i guess that I dont live in the right country to do what I want to do.

If someone knows a way to bypass this problem let me know.


Thanks

John Meyer
09-10-2002, 04:20 PM
I changed the country to United States (Which, as you pointed out gives you the "Data Type" Address 1 Column)

Then I selected Data Type City for the Province Column, clicked Finish and it imported just fine.

Give it another try, should work!

 
Web mp2kmag.com
mapforums.com