Export SQL to Excel @sathya.srinivasan I have been trying to use the

hayleyw over 10 years ago

Export SQL to Excel

@sathya.srinivasan I have been trying to use the Export SQL to Excel smart service but it is only returning values for a column that is a date field, it is not returning any of the varchar field values. Has the smart service been updated to process values other than Date and Integers?

Thanks

Discussion posts and replies are publicly visible

Parents

0 siddharthg521 over 10 years ago

Hi hayleyw,
I had observed the similar issue with this service in the past wherein the varchar field sometimes doesn't populate in excel using this service.

As a workaround, I changed the type of that field from varchar to nvarchar, and then tried to run this service and it successfully populated my excel !
Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 siddharthg521 over 10 years ago

Hi hayleyw,
I had observed the similar issue with this service in the past wherein the varchar field sometimes doesn't populate in excel using this service.

As a workaround, I changed the type of that field from varchar to nvarchar, and then tried to run this service and it successfully populated my excel !
Hope it helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data