Canadian Postal Code Database FAQs
- What methods of payment do you accept?
- Do you accept purchase orders?
- What format does the database come in?
- How do I get the monthly database updates?
- Will a CD be mailed to me? How do I get the database?
- What happens after my 1 year subscription?
- How much does it cost to renew?
- Do you include Postal Codes for all of Canada?
- How often do you update the database?
- How current is the data?
- How accurate is the data?
- Do you have any other countries besides Canada?
- How long does it take to get the data?
- Can I automate the database delivery?
Q. What methods of payment do you accept?
A. We accept Visa, Mastercard, American Express, and PayPal for immediate download. You can also place your order choosing Mail In Check or Purchase Order but you will be unable to download the database until your payment is received.
Back to Top
Q. Do you accept purchase orders?
A. Yes, we can accept purchase orders. Simply go through the order process as normal. When you come to the payment screen, choose Purchase Order as the payment type and complete your order. You can then print out a purchase order and mail in the payment. Once payment is received, access to download the database will be turned on.
Back to Top
Q. What format does the database come in?
A. Our Canadian Postal Code Database is provided in three (3) formats: Microsoft® Access [MDB], Microsoft® Excel [XLS], and ASCII Comma Delimited [CSV].
Back to Top
Q. How do I get the monthly database updates?
A. When you purchase, you setup a username and password. Each month, we will notify you via email that an update database is available. Visit our site and login using your username and password. The updated databases will be available for download in any format we provide as well as a transactional log file with just the changes only.
Back to Top
Q. Will a CD be mailed to me? How do I get the database?
A. No, our Canadian Postal Code Database is not mailed to you on CD. Once your order is completed, you will be able to download immediately. All monthly updates are also provided for online download. This ensures fastest delivery as the databse is updated each month.
Back to Top
Q. What happens after my 1 year subscription?
A. When your Canadian Postal Code Database subscription is expiring, we will notify you by email 30, 10, and 1 day in advance. You can choose to renew at the current rate, or let your subscription expire. You can continue to use the database after your subscription has expired, but the data will become outdated very quickly.
Back to Top
Q. How much does it cost to renew?
A. Currently, renewal prices are the same as the original purchase price.
Back to Top
Q. Do you include Postal Codes for all of Canada?
A. Yes. Postal Code data is provided for all Canadian provinces and territories.
Back to Top
Q. How often do you update the database?
A. Our Canadian Postal Code Database is updated every month.
Back to Top
Q. How current is the data?
A. Our Canadian Postal Code Database is updated every month. the data is current as of July, 2009
Back to Top
Q. How accurate is the data?
A. Accurate data is critical to the success of your business and ours. Zip-Codes.com implements a very rigorous set of data integrity checks to ensure our database is as accurate as possible. In the unlikely event that a portion of data is confirmed as innaccurate, we will correct it within 2 business days.
Back to Top
Q. Do you have any other countries besides Canada?
A. Yes. We also have the U.S. ZIP Code Database.
Back to Top
Q. How long does it take to get the data?
A. Instantly. As soon as your order is confirmed and payment is received, you will get the database immediately after purchase.
Back to Top
Q. Can I automate the database delivery?
A. Yes! Please email us requesting an FTP Account be setup for you to use in automating your processes. Please include your username or order number for reference. We will have it up and running within 1 hour.
Back to Top
Postal Code Tools & Resources
Zip-Codes.com offers it's client several free applications, tools, and sample code to all of it's client's. It's our way of saying thank you and helping you make the most of what we offer.
Database Scripts
These scripts work on yourSQL Server or MySQL Server establishing the table, columns, and column definitions before importing the data. To use them, execute the full file contents in Enterprise Manager, SQL Server Management Studio, phpMyAdmin, or other SQL Command Interface.
SQL Server 2000 & 2005
MySQL
Sample Code
The sample code provided here is meant as an example of how some functions can be performed.
Distance Functions:
Calculate the distance between two latitude/longitude coordinates.
| • VBScript |
[ View ] |
| • PHP |
[ View ] |
| • VB.Net |
[ View ] |
| • C# |
[ View ] |
| • Visual Basic (VB6) |
[ View ] |
| • Coldfusion |
[ View ] |
| • MS SQL Server [User defined scalar function] |
[ View ] |
Radius Finder
The Radius Finder Application is free for our all of our Canadian Postal Code Database Customers and comes bundled with the Access Database. It features:
- Unlimited Radius Searches
- Unlimited Radius Distance
- Works with U.S. & Canadian databases
- Population, Demographics & Business Data returned in the results
- Copy and Paste results into other applications
- Run searches for Multiple ZIP Code Radius' at the same time
- Export data to a CSV file
- Works on your computer, not online