This is similar to, but not the same as, a problem I posted about last month.
The gist:
I'm trying to paste data from Excel into an Access table; and there is one field that is causing me major agita. The field holds postal codes, which in the US are all numeric values. However, Canadian postal codes have values like "V1M 3A9" and "L6S 6G6". To accommodate this, I have set the destination field in the Access table with a Short Text data type, which is supposed to contain literal text data, regardless of whether the characters are alpha or numeric.
The problem is, when I paste the data into Access, the Canadian postal codes simply vanish without a trace, though no error message is given to indicate that values have been dropped. The rest of the data pastes just fine.
I have included a snapshot of the problem below. On the left is a sample of the data as it appears in the Excel sheet, and on the right is the same data as it appears in the Access table after pasting. Note that the Canadian postal codes are just gone.
City State Postal Code Consignee City Consignee State Consignee Post Code DINUBA CALIFORNIA 93618 DINUBA CALIFORNIA 93618 WOODLAND CALIFORNIA 95776 WOODLAND CALIFORNIA 95776 DINUBA CALIFORNIA 93618 DINUBA CALIFORNIA 93618 Langley British Columbia V1M 3A9 Langley British Columbia Brampton Ontario L6S 6G6 Brampton Ontario TORRANCE CALIFORNIA 90501 TORRANCE CALIFORNIA 90501 NICHOLS NEW YORK 13812 NICHOLS NEW YORK 13812
I cannot for the life of me figure out why this is happening. Can anybody shed some light on this for me?