External Data From Other Sources (From Microsoft Enquiry) will not display data with different formats

[Shins83]

I have a mirrored table so I can show selected data from a larger table. Problem is, one of the columns contains serial numbers which are a combination of number only and number and text values (i.e. 1208667 and 1029FB6). When I refresh my mirrored table, only the number values appear, not the values with a combination of text and numbers.

Does anyone have any idea on how to make all values appear in my mirrored tables?

Many thanks in advance.