CSV export - kills UTF8

hi
have form with sql table connected and allot of utf8 data stored
once its exported to csv - clicking export button -
the file downloaded to pc, double click it open in excel and all utf8 data is Gibberished and appear unreadable.

i would like to know where the export defined and what i need to add to this function in order to force it to be UTF8 and solve the problem

thank you
Barnea

Hi Barnea,

We've been here before and never fully resolved it but I think that this is mostly a problem with the Excel import. Try using the Data ribbon and then 'From Text' where you can choose the character set to use. Does that work OK?

Bob

hi
please explain where to find

Data ribbon and then 'From Text' and the character set to use

thanks
:)

Hi Barnea,

All in Excel.

Bob