Hi,
Hi,
We are trying to fetch record from MS Dataverse using ODBC driver 17/18 for Sql Server into Excel using Macro(VBA) code.
Issue: There are some columns with type nvarchar which are not showing in proper format as it shows for other columns.
I checked the Recordset for nvarchar type column field is showing Field Type = 202 and this Field DataType Enum = adVarWChar and ADO type = A null-terminated Unicode character string.
Code used to fetch Record:
Record Value of nvarchar column:
Any Help on this will be appreciated.
Thank You in advance.
