Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Export Quicken to Excel 2010

23 Dec 2010   #1
meebers

Windows 7 Professional X64 Service Pack 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 System SpecsSystem Spec
.
23 Dec 2010   #2
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

Hi Meebers,

Are you exporting to CSV from Quciken? How does the CSV look if you open it in a text editor?
My System SpecsSystem Spec
24 Dec 2010   #3
meebers

Windows 7 Professional X64 Service Pack 1
 
 

Quote   Quote: Originally Posted by Golden View Post
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.
My System SpecsSystem Spec
.

24 Dec 2010   #4
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

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 System SpecsSystem Spec
Reply

 Export Quicken to Excel 2010




Thread Tools




Similar help and support threads
Thread Forum
Export mailing labels from Word into Excel
How to export mailing labels from Word 2010 into Excel 2010 to upload to USPS for bulk mailing
Microsoft Office
How to export Outlook 2010 contacts to Excel?
I want to export all my contacts in Outlook 2010 to Excel. Suggestions? Why: I am fairly sure my outlook file is corrupt. I cannot see my contacts in category view as I did when I had the same program in WinXP (I upgraded to Win7.) After 8 months, the first category appeared in the Current...
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Export from WLM 2011 to Outlook 2010
How do I export accounts, folders and messages from Windows Live Mail (Version 2011, Build 15.4.3538.0513) and import them into Outlook 2010?
Browsers & Mail
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
export txt file from excel help
i have tried (and succeeded) to export a txt file from excel 2010 but each column is separated by a tab and i want it to be separated by a "|" character so it can be used in a program i have edited thanks
Microsoft Office


Our Sites

Site Links

About Us

Find 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 21:15.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App