Populating a US MAP

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

re: Populating a US MAP

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 (MVP)
Edmonton, Alberta Canada
NoooSPAmkallal@msn.com
http://www.attcanada.net/~kallal.msn

re: Populating a US MAP

"Albert D. Kallal" <pleasenonosspammkallal@msn.com> wrote in message
news:Xbxvb.451331$pl3.420798@pd7tw3no...[color=blue]
> 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.[/color]

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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/2003

re: Populating a US MAP

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 (MVP)
Edmonton, Alberta Canada
NoooSPAmkallal@msn.com
http://www.attcanada.net/~kallal.msn

re: Populating a US MAP

"Albert D. Kallal" <pleasenonosspammkallal@msn.com> wrote in message
news:uFzvb.452789$6C4.248080@pd7tw1no...[color=blue]
> 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.[/color]

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