PDA

View Full Version : Basic - Zip Code Data (Bubble Diagram)



robertuva
09-26-2005, 12:54 PM
I am trying to build out a map diagram that takes 330,000 records with just zip codes that does a count and then presents a visual on a map (in the form of a bubble; more records = larger bubble) for Metro areas, etc. The problem is when I import my Access db it seems to run over the majority of records. How can I do this?

Bobby

I.T.
09-27-2005, 03:01 PM
You would probably be a lot quicker using a "Make Table" query in Access to make a table first then importing the results into MapPoint

The SQL would be something like:-

SELECT ZipTable.ZipCode, Count(ZipTable.ZipCode) AS CountOfZipCode INTO [Make Table]
FROM ZipTable
GROUP BY ZipTable.ZipCode;

This will reduce your 330,000 records into however many different Zip Codes you have in your table. I just tried this on a table with 410,000 records and it took about 2 or 3 seconds. A lot easier than trying to import them all then doing the maths.

Hope this helps

Iain T.