[Solved] Import MS Money files

Not sure where to post? Post here!

[Solved] Import MS Money files

Postby steven061 » Wed Sep 01, 2010 10:06 pm

Hi all
I use OpenOffice 3.0.0. and have also used MS Money for a number of years. I would like to transfer all the MS Money data to OpenOffice (Calc or Base). I would then directly download my account transactions from my online bank account to OpenOffice for analysis.

Is it possible to import MS Money data to OpenOffice? I have tried searching this forum and the How to guides for an answer with no success.

Any help greatly appreciated.

Regards

Steven
Last edited by steven061 on Wed Sep 08, 2010 3:39 pm, edited 2 times in total.
OpenOffice 3.1 on Windows Vista
steven061
 
Posts: 2
Joined: Wed Sep 01, 2010 9:47 pm

Re: Import MS Money files

Postby TheGurkha » Wed Sep 01, 2010 11:03 pm

There is no equivalent to Money in OOo, sorry. If you did manage to export in a format that Calc could read it would be a view of your data only, not the functional accounting system that Money is.
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Import MS Money files

Postby BigJohnson963 » Sun Sep 05, 2010 1:54 am

I'm stuck at the same problem. It would be really useful to import .QIF files so the data can be viewed in a spreadsheet. I don't need any added accounting functionality. Is this possible to do with a basic import function? I've tried using the data pilot, but the "external source" option never works. Any help would be much appreciated.
OpenOffice.org 3; Windows 7
BigJohnson963
 
Posts: 1
Joined: Sun Sep 05, 2010 1:43 am

Re: Import MS Money files

Postby therabi » Sun Sep 05, 2010 2:04 am

BigJohnson963 wrote:I'm stuck at the same problem. It would be really useful to import .QIF files so the data can be viewed in a spreadsheet. I don't need any added accounting functionality. Is this possible to do with a basic import function? I've tried using the data pilot, but the "external source" option never works. Any help would be much appreciated.


From the .QIF I take it that your using either Quick Books or Quicken. You can export the data from them as a CSV file and then open the file with Calc. The Import Text screen with open if everything look right click OK and it will show in Calc.

HTH
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
User avatar
therabi
Volunteer
 
Posts: 763
Joined: Wed Sep 01, 2010 10:01 pm
Location: USA

Re: Import MS Money files

Postby Villeroy » Sun Sep 05, 2010 2:12 am

Like MS Access MS Money is based on the Microsoft JET database engine. Therefore it has nothing in common with any spreadsheet program. On a Windows system with the required database drivers ("connectivity tools") it may be possible to establish a Base connection.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17262
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Import MS Money files

Postby steven061 » Wed Sep 08, 2010 3:32 pm

Success!!!!

I managed to transfer all my MS Money 2005 data to Calc and it works. Firstly, within MS Money left click on Reports then left click on export to desktop (Ihad the All Accounting Data box ticked). A text file will be created on your desktop. Then right click the new desktop icon and left click open with Calc. The data has loaded into Calc and allows analysis (more than 20 years worth).

Hope this helps.

Regards

Steven
OpenOffice 3.1 on Windows Vista
steven061
 
Posts: 2
Joined: Wed Sep 01, 2010 9:47 pm


Return to Beginners

Who is online

Users browsing this forum: No registered users and 9 guests