FileScriptingObject reading textfiles with "strange" characters RRS feed

  • Question

  • I'm importing textfile data from SAP with VBA (MS ACCESS 2010). The file is fixed width seperated by |

    reading a line is no problem, but when I try to read lines with data from Sweden I have problems with the characters å and ø.

    these characters are not imported correctly, somehow only simple latin characters can be read this way, although my export file has lots of foreign characters. Does anyone have a clue to solve this?

    Thursday, December 1, 2011 12:39 PM


  • Dear Albert-Jan,

    Please take a look at these articles or threads:

    Hope this helps.


    Be happy.
    • Marked as answer by Bruce Song Tuesday, December 20, 2011 2:24 AM
    Monday, December 5, 2011 8:57 AM