I pretend to import a TXT file to Customer table.
My TXT file has name field with specific accents. All names are coorect.
When I imprt TXT file with my dataport de reslt is bad on name fields with that accents.
EX:Caniço after import to navision stays like Caniþo
José after import to navision stays like JosÚ
My DB is SQL and I use SQL Colletion 54
It should be the same. And thats the format which has always worked for me. How is it looking before you convert it?
Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.
When you import using the classic client then you have to remember that NAV text is in ASCII format, whilst your file most like is in ANSI format. So you need to either convert your file manually before importing, or build in an ASCII to ANSI convertor.
After convert the file to ASCII, in what format can I saved my new file to import to Navision correctly?
You have to save the file to MS-DOS ASCII format for it to import correctly to Navision.
I don't have this file format : MS-DOS ASCII format MS-DOS ASCII :(
Then try to open it with WORDPAD and save-as from here.
No way, I only have available the Format MS-DOS (txt), and this one creats a file with a bad result.
Thanks Erik, it's ok now. Regards
© 1995-2013 Dynamics User Group, all rights reserved.