Hello all,

I have a fixed width text file in ANSI coding and I am trying to link it in Access 2007; however after I link it in access, some chinese font are displayed as some weird symbols like this "港口建设费"

May i ask if there is any way that i can fix this?

I know I can open the file in notepad and save it again in Unicode, but the text file is pretty large and it's almost impossible to just open it using notepad.

Any ideas would be appreciate. Thanks in advanced.