...
| Code Block |
|---|
GetForeignIdsCommand = "SELECT Personalnummer FROM Personendaten.csv" |
To import a file in UTF-8 format you need to add CharacterSet=65001 to the end of the connection string. As an example:
| Code Block |
|---|
CustomConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\temp;Extended Properties='Text;CharacterSet=65001'" |
Check CSV import locally with Powershell
...