Dataverse sql server - nvarchar column not showing in proper format in excel vba recordset field..

(0) Share

Report

Posted on by gbhagia

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.

Categories:

Microsoft Dataverse

All responses (2)

Answers (0)

gbhagia 2 on at

Like (0)

Report

Re: Dataverse sql server - nvarchar column not showing in proper format in excel vba recordset field..

Hi,
Is this what your are asking for?
Ram Prakash 5,166 Super User 2025 Season 1 on at

Like (0)

Report

Re: Dataverse sql server - nvarchar column not showing in proper format in excel vba recordset field..

Hi @gbhagia

Can you please show me the Table Structure.