Export Quicken to Excel 2010


  1. Posts : 327
    Windows 7 Professional X64 Service Pack 1
       #1

    Export Quicken to Excel 2010


    When exporting some of the reports generated in Quicken 2010 to Excel 2010, some headers appear with chinese/japanese characters. i.e. http://img5.imageshack.us/img5/4139/chinesetext.jpg. Anybody seen this before??
      My Computer


  2. Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       #2

    Hi Meebers,

    Are you exporting to CSV from Quciken? How does the CSV look if you open it in a text editor?
      My Computer


  3. Posts : 327
    Windows 7 Professional X64 Service Pack 1
    Thread Starter
       #3

    Golden said:
    Hi Meebers,

    Are you exporting to CSV from Quciken? How does the CSV look if you open it in a text editor?
    When exporting data from quicken, the choice of "report to excel compatable format" is a tab delimited txt file. This looks normal when viewed in a txt editor. However, when I started the delimiting process in Excel, I noticed that Excel thought it was a "936 chinese simplified (GB2312)" type text. I then selected 20127 US-ASCII as the default and that produced normal results. Have been doing excel for 10 yrs and still learn something everyday. I then generated a simple txt type tab delimited file in notepad, opened that file in Excel and it correctly identified the text as a 437:OEM United States File Origin. Why Excel thinks that Quicken reports are chinese type txt file is a question. (Maybe Quicken is writen by Chinese programers) Tx for giving me a path to find the solution.
    Last edited by meebers; 24 Dec 2010 at 15:59.
      My Computer


  4. Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       #4

    Cool. I find this kind of problem often when trying to export to Excel compatible formats with lots of other software. I now always go to CSV/ASCII, and then import that into XLX.

    Regards,
    Golden
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 03:16.
Find Us