Sage 100

Customer wants a source for complete list of Canada and possibly some overseas zip codes. What have you used as the source to import these codes?

Free zip code database - here are the Canadian ones for a year ago. They are tilde delimited.

Thanks this is helpful. Looks like there are multiple postal codes pointing to the same province and country code. Is this accurate? I presume that the zip is somehow related to the exact location.

I believe it's accurate and yes the zip code would be a more exact location (postal address). This is from Wiki: A Canadian postal code is a six-character string that forms part of a postal address in Canada.[1] Like British and Dutch postcodes, Canada's postal codes are alphanumeric. They are in the format A1A 1A1, where A is a letter and 1 is a digit, with a space separating the third and fourth characters. As of January 2014, there are 845,990 postal codes [2] using Forward Sortation Areas from A0A in Newfoundland to Y1A in Yukon

Moira's gets very close...