mmartin
05-30-2007, 07:22 AM
Hello,
Does anyone know if it is possible in any way to get access to the values of the MP demographic data? That is, not just the field name but the actual numeric value?
Thanks
MLM
Eric Frost
05-30-2007, 03:09 PM
All the demographics are in an mdb file (Access database) in the MapPoint directory.
I know people had figured out the password for the mdb file in the past -- does anyone remember what it would be for MapPoint 2006 ?
Something like geo13na ?
Eric
mmartin
05-30-2007, 03:45 PM
Thanks Eric,
Yes it would be helpful if someone did know the Password. (But, also, I wanted to confirm that it is not possible to get the values in a program, that is, not only get the name of geodemographic field, but the value?. I don't think it is - i guess you can only query and get values on none geodemographic data sets- , but wanted to confirm.
Best
M. Martin
Eric Frost
05-30-2007, 06:08 PM
Yes definitely - first map whatever demographic variable at whatever geographic level you desire and then draw a big rectangle or circle over the area you wish to export using the drawing tools.
Then right click on the rectangle or circle and do an Export to Excel. I'm sure this requires that Excel be installed :-) but that's it!
Let me know if it would help for me to post a screenshot and an Excel file to illustrate, I would be happy to do it.
Eric
mmartin
05-31-2007, 06:49 AM
Thanks Again Eric,
That's a good idea - the Excel export- but, any ideas how I can get the geographic data values in the code - that is, I need to get the values into veriables in a routine and then add several together - I'm trying to create a composit demograpich of certain ages and ethnic data - and then use the data mathematically. ?
Thanks Again,
MLM
Eric Frost
05-31-2007, 08:12 AM
No, I think you'd have to Export to Excel and then pick up the values from there.
Eric