Hi all,
Can anyone recomend a db with all the countries, zips, cities, states....
that I can incorporate into my db? I would like to set it up so when I enter
a new client lets say, I choose a country, that sets the related txt boxes
for the city, state, and zip per that country for user to enter the address,
city, state and zip so to speak. Being different countries (other than USA)
have different formats, I would like to incoprporate these automatically as I
have a few clients and suppliers in other countries and when it comes into
the address, currently I only have for USA and that makes a mess of data so
to speak.

I am quite sure someone somewhere has all ready achieved this so i dont want
to recreate the wheel. Any recomendations would be helpful.

Thanks
Dave
--
If your server / PC doesnt contain the word "Supermicro" then you have no
idea what you are missing!

I've never seen an Access database that incorporates all countries. zip
codes, etc. Even a properly indexed US one is over 10 MB, so I'd expect a
full world wide one to be 150 MB or more. You might find something in
SQL-Server or another server based database engine that large, but I'd
expect it would be expensive.

The only international MS-Access database that I've seen is the Northwind
sample database that comes with Access, but of course it doesn't store any
lookup data.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"David Pierce" <(E-Mail Removed)> wrote in message
news:436001D5-3657-41EF-B349-(E-Mail Removed)...
> Hi all,
> Can anyone recomend a db with all the countries, zips, cities, states....
> that I can incorporate into my db? I would like to set it up so when I
> enter
> a new client lets say, I choose a country, that sets the related txt boxes
> for the city, state, and zip per that country for user to enter the
> address,
> city, state and zip so to speak. Being different countries (other than
> USA)
> have different formats, I would like to incoprporate these automatically
> as I
> have a few clients and suppliers in other countries and when it comes into
> the address, currently I only have for USA and that makes a mess of data
> so
> to speak.
>
> I am quite sure someone somewhere has all ready achieved this so i dont
> want
> to recreate the wheel. Any recomendations would be helpful.
>
> Thanks
> Dave
> --
> If your server / PC doesnt contain the word "Supermicro" then you have no
> idea what you are missing!

I think the United Nations Statistics division sells a worldwide city db.
See what you can find on their website. Address correction software, like
Address Doctor or Group One, includes this kind of data down to the street
address level, but it's large and expensive.

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> I've never seen an Access database that incorporates all countries. zip
> codes, etc. Even a properly indexed US one is over 10 MB, so I'd expect a
> full world wide one to be 150 MB or more. You might find something in
> SQL-Server or another server based database engine that large, but I'd
> expect it would be expensive.
>
> The only international MS-Access database that I've seen is the Northwind
> sample database that comes with Access, but of course it doesn't store any
> lookup data.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "David Pierce" <(E-Mail Removed)> wrote in message
> news:436001D5-3657-41EF-B349-(E-Mail Removed)...
>> Hi all,
>> Can anyone recomend a db with all the countries, zips, cities, states....
>> that I can incorporate into my db? I would like to set it up so when I
>> enter
>> a new client lets say, I choose a country, that sets the related txt
>> boxes
>> for the city, state, and zip per that country for user to enter the
>> address,
>> city, state and zip so to speak. Being different countries (other than
>> USA)
>> have different formats, I would like to incoprporate these automatically
>> as I
>> have a few clients and suppliers in other countries and when it comes
>> into
>> the address, currently I only have for USA and that makes a mess of data
>> so
>> to speak.
>>
>> I am quite sure someone somewhere has all ready achieved this so i dont
>> want
>> to recreate the wheel. Any recomendations would be helpful.

David,

This is the one I use for the US and Canada... http://www.zipcodeworld.com/

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"David Pierce" <(E-Mail Removed)> wrote in message
news:436001D5-3657-41EF-B349-(E-Mail Removed)...
> Hi all,
> Can anyone recomend a db with all the countries, zips, cities, states....
> that I can incorporate into my db? I would like to set it up so when I
> enter
> a new client lets say, I choose a country, that sets the related txt boxes
> for the city, state, and zip per that country for user to enter the
> address,
> city, state and zip so to speak. Being different countries (other than
> USA)
> have different formats, I would like to incoprporate these automatically
> as I
> have a few clients and suppliers in other countries and when it comes into
> the address, currently I only have for USA and that makes a mess of data
> so
> to speak.
>
> I am quite sure someone somewhere has all ready achieved this so i dont
> want
> to recreate the wheel. Any recomendations would be helpful.
>
> Thanks
> Dave
> --
> If your server / PC doesnt contain the word "Supermicro" then you have no
> idea what you are missing!

On 3 jan, 15:59, David Pierce <dp.david.pie...@gmail.com> wrote:
> Hi all,
> Can anyone recomend a db with all the countries, zips, cities, states....
> that I can incorporate into my db? I would like to set it up so when I enter
> a new client lets say, I choose a country, that sets the related txt boxes
> for the city, state, and zip per that country for user to enter the address,
> city, state and zip so to speak. Being different countries (other than USA)
> have different formats, I would like to incoprporate these automatically as I
> have a few clients and suppliers in other countries and when it comes into
> the address, currently I only have for USA and that makes a mess of data so
> to speak.
>
> I am quite sure someone somewhere has all ready achieved this so i dont want
> to recreate the wheel. Any recomendations would be helpful.
>
> Thanks
> Dave
> --
> If your server / PC doesnt contain the word "Supermicro" then you have no
> idea what you are missing!

I think it will be a problem to build something like this for every
country in the world. Every country has its own system of postal
codes. For example in an smal country like The Netherlands where I
live there are more than 600,000 codes. One postal code belongs to a
part of a street (from house number to house number).

You can find the dutch codes in a database on my site (http://
access.xps350.com).

Groeten,

Peter
http://access.xps350.com

I should note that mine is stored on an SQL Server as it's 800,000 +, Canada
being the bulk of that.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Gina Whipp" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> David,
>
> This is the one I use for the US and Canada...
> http://www.zipcodeworld.com/
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "David Pierce" <(E-Mail Removed)> wrote in message
> news:436001D5-3657-41EF-B349-(E-Mail Removed)...
>> Hi all,
>> Can anyone recomend a db with all the countries, zips, cities, states....
>> that I can incorporate into my db? I would like to set it up so when I
>> enter
>> a new client lets say, I choose a country, that sets the related txt
>> boxes
>> for the city, state, and zip per that country for user to enter the
>> address,
>> city, state and zip so to speak. Being different countries (other than
>> USA)
>> have different formats, I would like to incoprporate these automatically
>> as I
>> have a few clients and suppliers in other countries and when it comes
>> into
>> the address, currently I only have for USA and that makes a mess of data
>> so
>> to speak.
>>
>> I am quite sure someone somewhere has all ready achieved this so i dont
>> want
>> to recreate the wheel. Any recomendations would be helpful.
>>
>> Thanks
>> Dave
>> --
>> If your server / PC doesnt contain the word "Supermicro" then you have no
>> idea what you are missing!
>
>

"Gina Whipp" <(E-Mail Removed)> wrote:

>I should note that mine is stored on an SQL Server as it's 800,000 +, Canada
>being the bulk of that.

That would make sense as our postal codes go down to the block level.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

Interesting, I guess that explains why I get more Canadian postal code
updates then US, alot more *new* construction!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Tony Toews [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Gina Whipp" <(E-Mail Removed)> wrote:
>
>>I should note that mine is stored on an SQL Server as it's 800,000 +,
>>Canada
>>being the bulk of that.
>
> That would make sense as our postal codes go down to the block level.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> For a convenient utility to keep your users FEs and other files
> updated see http://www.autofeupdater.com/
> Granite Fleet Manager http://www.granitefleet.com/

"Gina Whipp" <(E-Mail Removed)> wrote:

>Interesting, I guess that explains why I get more Canadian postal code
>updates then US, alot more *new* construction!

More like that for each street added in Canada that could be two or
twenty postal codes. But a five digit zip code covers a lot more
territory.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

Almost feel sorry for the Mail Person!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Tony Toews [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Gina Whipp" <(E-Mail Removed)> wrote:
>
>>Interesting, I guess that explains why I get more Canadian postal code
>>updates then US, alot more *new* construction!
>
> More like that for each street added in Canada that could be two or
> twenty postal codes. But a five digit zip code covers a lot more
> territory.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> For a convenient utility to keep your users FEs and other files
> updated see http://www.autofeupdater.com/
> Granite Fleet Manager http://www.granitefleet.com/