Excel (for reasons I have not yet determined), cannot handle imported Guids natively. In order to import GUIDs from SQL Server, you must first change the query to CAST the Guid to an nvarchar
. The data source query would change to:
SELECT CAST(ThingID as nvarchar(100)), ThingName from TABLENAME
The CAST
function ensures that the GUID is in a format that Excel interprets as text. Any format that outputs text will do; it doesn't have to be nvarchar
.