Excel Read Range of strings into datatable adds quotation marks to some strings

Help Activities
, ,
6

Hi,

I directly checked the string data inside the xlsx file. However, there is no special character including double quote.

image

i guess it’s caused by comma in each data. If you need to remove the double quotes, Trim(Chr(34)) may help you as workaround.

Regards,

1 Like
Forum Engagement Daily Reports