AnySite 9.x and importing zipcodes to create a linked layer of zipcode regions

Product Affected: AnySite™
 

Issue

User running AnySite 9.1 US has an Excel file of some 700 zipcodes that they wish to import  and then create a linked layer of zipcode regions.

Some of the zipcodes are in CT, so they start with a zero.

When following the correct steps to create a linked layer of zipcode regions
(i.e. create a database with Database Manager, then link to the zipcode boundary table),
the resultant table is made up of ALL zipcode regions in the US and not just the 700 expected

User-added image

Cause

For reasons still being investigated, the process seems to fail because of zipcodes with leading zero's having the 0's truncated, as the zipcodes come in as numeric and not character data.
Ideally, Anysite should not show any records that fail to join but instead joins to every zipcode.

Resolution

UPDATED: July 16, 2019
First save the .xlsx/.xls file of ZIPCODES as a .txt file and then open the file in Excel.
 
The Text Import Wizard will appear. in Step 1 of 3, select Delimited and click Next

User-added image
 
Click Next
User-added image
 
Set the ZIPCODE column to Text and click Finish
User-added image
 
Leading zeroes are now present:

User-added image
 
Save the .txt file as a .xls or xlsx file. Import the xls in AnySite's Data Manager and create a "linked" layer:
User-added image



Note: if user has MapInfo Pro, they can easily open the original xlsx in Pro and then open the zipcode boundary file from the AnySite datqa folder and
join the 2 tables where zip = zip and then save the qyery as a new mappable table to import directly in to AnySite