Populating a US MAP

  • Thread starter Thread starter Jeff Clarke
  • Start date Start date
J

Jeff Clarke

Any ideas on how I can populate a US map. I have a database with a field named State, I've created a crosstab query linking another table with all the states .... but I'm unable to create a new field for each state so that I can populate it.

Thanks in advance
 
Excel has an optional mapping feature (I don't think it is installed by
default, but check your install). I would check that out first.

Also, Viso is capable of doing this kind of stuff also.
 
Albert D. Kallal said:
Excel has an optional mapping feature (I don't think it is installed by
default, but check your install). I would check that out first.

Also, Viso is capable of doing this kind of stuff also.
Click to expand...

In addition MapPoint can do it and interface with queries in Access
databases. MapPoint is also fully programmable with VBA so it can work with
automation from Access.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Gee, and I was just playing with MapPoint about two months ago.

Funny, that slipped my mind.

In fact, MapPoint even has some built in wizards and the like that will
import ms-access data.
 
Albert D. Kallal said:
Gee, and I was just playing with MapPoint about two months ago.

Funny, that slipped my mind.

In fact, MapPoint even has some built in wizards and the like that will
import ms-access data.
Click to expand...

It's been a little while since I've worked with it too, but the startup of
MapPoint and the import can also be initiated from Access VBA code.

The real power of Access is in VBA and the way it interacts with so many
other VBA compliant applications. As the youngsters would say:

Access Rulz! <lol>
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top