I was able to get this import of zip codes and states to import through the AX 2012 Rapid Start tool. It has an option where you select if you wish to import these. Your partner can help you with you with this. Free Zip Code, City, County, State, CSV. By Phil Steffek; on November 4, 2011; under Business Intelligence, Scripts • 28 Comments Free Download of the zip code CSV file available at the bottom of this post. Why this is so hard to track down I don’t know.
Our ZIP Code Database is set of all U.S. ZIP code data put into row and column format for easy use and manipulation. The free version comes with 7 data fields for every ZIP code in the United States.
It has all the basic information you need to validate ZIP Code entry and basic mapping. The Free ZIP Code database is for personal use only and may not be used commercially or redistributed in any manner. • Use our ZIP Code data on your website for easy lookups and data filling • Multiple data formats - Excel, Access, CSV, and SQL for easy use • Immediately download the data • 2010 Census Population • Updated Monthly. An email will be sent to the address entered confirmation before you can download. Need More Detailed Data? Try our professional ZIP Code Databases • Immediate Download after purchase • 1 Year Subscription with Monthly Updates • Multi-Year Licenses available • All subscriptions are not automatically renewed.
• Visa, Mastercard, American Express, or Mail In Check/Purchase Order accepted • Download all file formats if needed (Access, Excel, Comma Delimited, and SQL) • Learn more about our Professional. Database Technical Specifications Downloads • Free Database: [ ] • Standard Database: [ ] () • Deluxe Database: [ ] () • Business Database: [ ] () Field Name Data Type Description ZipCode Char(5) 9 Five digit numeric ZIP Code of the area. State Char(2) 2 letter state name abbreviation. City VarChar(35) Name of the city as designated by the USPS.
Latitude Decimal(12, 4) Geographic coordinate as a point measured in degrees north or south of the equator. Longitude Decimal(12, 4) Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian. ClassificationCode Char(1) The classification type of this ZIP Code. Population Integer The population of the ZIP Code based on 2010 Census data. ZIP Code Database FAQs • • • • • • • • • • • • • • • • • • Q. What format does the database come in? Our US ZIP Code Database is provided in three (3) formats: Microsoft® Access [MDB], Microsoft® Excel [XLS], and ASCII Comma Delimited [CSV].
How do I get the monthly database updates? When you purchase, you setup a username and password. Each month, we will notify you via email that an updated database is available.
Reflect on back side – When enabled, reflections will be computed for back-facing surfaces too. Dim distance – Specifies the distance after which the reflection rays will not be traced. Note that this affects total internal reflections too (when refractions are computed).