Populating a US MAP

[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

 

[Albert D. Kallal]

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.

 

[Arvin Meyer]

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.

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

 

[Albert D. Kallal]

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.

 

[Arvin Meyer]

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.

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