When I try to use Excel 2013 to import External Data from a SQL Server Data Source, it does not import the Guids.
The Query I'm using is:
SELECT * FROM TABLENAME
The table Structure is:
ThingId uniqueidentifier,
ThingName nvarchar(50)
When I explicitly ask Excel to import just the uniqueidentifier
, it imports nothing (query):
SELECT ThingId from TABLENAME
How do I get Excel to import Unique Identifiers (GUIDs) when I use the "External Data" feature?
No comments:
Post a Comment