I have an app in which CSV files import client data. These CSV files have been in English but are now starting to arrive in French where Entreés shows up as Entrées. These CSV files are saved as UTF-8 by the client's system.

I can't seem to find how to get the file to convert so that the French characters appear as they should. CPCURRENT(1) returns 1252 and CPCURRENT(2) returns 437. I've tried all the codepages in the line of code importing the file:

APPEND FROM [csvfilename] TYPE CSV AS [nCodePage]

but without success. I'm probably missing something stupidly basic, but can't seem to find how to get the file to translate properly. Any ideas?

Many thanks,
Dave