Saturday, 5 January 2019

sql server - Excel does not import Guids (Unique Identifiers) when importing data using the "External Data" feature

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

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...