Get External Data From Access—Column Empty

I created a new Excel 2010 file and used the 'Get External Data' to retrieve data 'From Access' in the form of an Excel table, however when the table is populated, the contents of one column remains empty. The data for all the thirteen other columns populate just fine but for this one column there is no data.

I have an database in Access 2010. There are only two tables. One table is a linked table to another Excel file. The other table is a linked table to another database via an ODBC. (I am certain the problem is not in the ODBC.)

The database contains several queries that extract data from the two linked tables, join and combine the data, until a single output datasheet is the result.

Part of that result are two derived columns.
The values in one derived column are either a text string or is NULL.
The values in the other derived column are either numerical (double datatype) or NULL.

It is the contents of the derived column with numerical values that do not populate in the Excel file.
The derived column that contains text does populate.

I have tried changing the column name.
I have tried moving the portion of the SQL script that derives the column to a subquery.
I have converted the number datatype to a string datatype
None of these had any effect on the results in Excel.


Does anyone have any suggestions?