I have a requirement to read and import data from MS Money data file. How can I achieve this? Is there a SDK available?
我需要从MS Money数据文件中读取和导入数据。我怎样才能做到这一点?有SDK可用吗?
I would like to have a similar mechanism to read Quicken files too.
我想有一个类似的机制来读取Quicken文件。
5 个解决方案
#1
With Microsoft discontinuing the MS Money product, I was researching the same issue to try to do a full data export of MS Money data file transaction information. The best I have been able to come across was a forum posting detailing manipulating the file to be readable via MS Access. Unfortunately, his method required purchasing a piece of software to "repair" the file to make it openable. The thread is here: http://www.archivum.info/microsoft.public.money/2007-09/msg00739.html and the text is below.
随着微软停止使用MS Money产品,我正在研究同样的问题,试图对MS Money数据文件交易信息进行全数据导出。我能够遇到的最好的是一个论坛帖子详细说明操纵文件可通过MS Access读取。不幸的是,他的方法需要购买一个软件来“修复”文件以使其可打开。线程在这里:http://www.archivum.info/microsoft.public.money/2007-09/msg00739.html,文字如下。
Well for $300 bucks + some custom SQL programming I finally found a way to get out of Money jail. Here is how
好吧300美元一些+一些自定义SQL编程我终于找到了摆脱Money*的方法。这是怎么回事
- Get FileBinReplace utility here http://www.softtreetech.com/24x7/script.htm
在这里获取FileBinReplace实用程序http://www.softtreetech.com/24x7/script.htm
- Run it as FileBinReplace *.mny "MSISAM Database" "Standard Jet DB"
运行它作为FileBinReplace * .mny“MSISAM数据库”“标准Jet DB”
- Rename *.mny to *.mdb
将* .mny重命名为* .mdb
- Use AccessFIX tool ($300; search the web for a download link) to repair the MDB file.
使用AccessFIX工具(300美元;在Web上搜索下载链接)来修复MDB文件。
Query TRN and TRN_INVOICE tables as needed.
根据需要查询TRN和TRN_INVOICE表。
By the way, when I saw the internal database design in Money, I was literally shocked. That database was surely designed by entry-level database programmers… students maybe… who had little idea about relational database design, normalization or efficiency... Just for the record, invoice text strings (addresses, customer notes, lines item descriptions, etc.. are stored tin the same table where on-line transactions are stored, invoice headers and details are stored in the same table!!! you get the idea about who and how designed it)
顺便说一下,当我在Money中看到内部数据库设计时,我真的很震惊。该数据库肯定是由入门级数据库程序员设计的......学生可能......对关系数据库设计,规范化或效率一无所知......只是为了记录,发票文本字符串(地址,客户备注,行项目描述等)。 。存储在同一个存储在线交易的表中,发票标题和详细信息存储在同一个表中!!!你可以了解设计的人和设计方法)
I would hope since MS is no longer going to support the product or data file format that they would release the data file spec so that tools could be created to properly export existing data.
我希望由于MS不再支持他们发布数据文件规范的产品或数据文件格式,因此可以创建工具来正确导出现有数据。
Here is also a SourceForge project for exporting MsMoney data in other formats: http://sunriise.sourceforge.net/
这里还有一个SourceForge项目,用于以其他格式导出MsMoney数据:http://sunriise.sourceforge.net/
#2
There is a "Class to transform an OFX (Microsoft Money) file into a DataSet" on CodeProject.
在CodeProject上有一个“将OFX(Microsoft Money)文件转换为DataSet的类”。
#3
OFX has nothing to do with MS Money data file (mny). OFX is an open standard based on sgml or xml depending on OFX version, MNY is a proprietary binary format. MS Money can import OFX files but that's all.
OFX与MS Money数据文件(mny)无关。 OFX是基于sgml或xml的开放标准,取决于OFX版本,MNY是专有的二进制格式。 MS Money可以导入OFX文件,但这就是全部。
If the requirement is to import only once then export from Money to csv or qif and process the exported files. Same applies to Quicken.
如果要求只导入一次,则从Money导出到csv或qif并处理导出的文件。同样适用于Quicken。
Money Sunset is free.
钱日落是免费的。
#4
If you are looking for a UK version, try http://www.microsoft.com/en-us/download/details.aspx?id=26915
如果您正在寻找英国版本,请尝试http://www.microsoft.com/en-us/download/details.aspx?id=26915
#5
This tool is free and will perform a more comprehensive export of Microsoft Money data. I don't think it can be used programatically though. http://www.ultrasoft.com/MoneyLink/overview.shtml
此工具是免费的,将执行更全面的Microsoft Money数据导出。我不认为它可以以编程方式使用。 http://www.ultrasoft.com/MoneyLink/overview.shtml
#1
With Microsoft discontinuing the MS Money product, I was researching the same issue to try to do a full data export of MS Money data file transaction information. The best I have been able to come across was a forum posting detailing manipulating the file to be readable via MS Access. Unfortunately, his method required purchasing a piece of software to "repair" the file to make it openable. The thread is here: http://www.archivum.info/microsoft.public.money/2007-09/msg00739.html and the text is below.
随着微软停止使用MS Money产品,我正在研究同样的问题,试图对MS Money数据文件交易信息进行全数据导出。我能够遇到的最好的是一个论坛帖子详细说明操纵文件可通过MS Access读取。不幸的是,他的方法需要购买一个软件来“修复”文件以使其可打开。线程在这里:http://www.archivum.info/microsoft.public.money/2007-09/msg00739.html,文字如下。
Well for $300 bucks + some custom SQL programming I finally found a way to get out of Money jail. Here is how
好吧300美元一些+一些自定义SQL编程我终于找到了摆脱Money*的方法。这是怎么回事
- Get FileBinReplace utility here http://www.softtreetech.com/24x7/script.htm
在这里获取FileBinReplace实用程序http://www.softtreetech.com/24x7/script.htm
- Run it as FileBinReplace *.mny "MSISAM Database" "Standard Jet DB"
运行它作为FileBinReplace * .mny“MSISAM数据库”“标准Jet DB”
- Rename *.mny to *.mdb
将* .mny重命名为* .mdb
- Use AccessFIX tool ($300; search the web for a download link) to repair the MDB file.
使用AccessFIX工具(300美元;在Web上搜索下载链接)来修复MDB文件。
Query TRN and TRN_INVOICE tables as needed.
根据需要查询TRN和TRN_INVOICE表。
By the way, when I saw the internal database design in Money, I was literally shocked. That database was surely designed by entry-level database programmers… students maybe… who had little idea about relational database design, normalization or efficiency... Just for the record, invoice text strings (addresses, customer notes, lines item descriptions, etc.. are stored tin the same table where on-line transactions are stored, invoice headers and details are stored in the same table!!! you get the idea about who and how designed it)
顺便说一下,当我在Money中看到内部数据库设计时,我真的很震惊。该数据库肯定是由入门级数据库程序员设计的......学生可能......对关系数据库设计,规范化或效率一无所知......只是为了记录,发票文本字符串(地址,客户备注,行项目描述等)。 。存储在同一个存储在线交易的表中,发票标题和详细信息存储在同一个表中!!!你可以了解设计的人和设计方法)
I would hope since MS is no longer going to support the product or data file format that they would release the data file spec so that tools could be created to properly export existing data.
我希望由于MS不再支持他们发布数据文件规范的产品或数据文件格式,因此可以创建工具来正确导出现有数据。
Here is also a SourceForge project for exporting MsMoney data in other formats: http://sunriise.sourceforge.net/
这里还有一个SourceForge项目,用于以其他格式导出MsMoney数据:http://sunriise.sourceforge.net/
#2
There is a "Class to transform an OFX (Microsoft Money) file into a DataSet" on CodeProject.
在CodeProject上有一个“将OFX(Microsoft Money)文件转换为DataSet的类”。
#3
OFX has nothing to do with MS Money data file (mny). OFX is an open standard based on sgml or xml depending on OFX version, MNY is a proprietary binary format. MS Money can import OFX files but that's all.
OFX与MS Money数据文件(mny)无关。 OFX是基于sgml或xml的开放标准,取决于OFX版本,MNY是专有的二进制格式。 MS Money可以导入OFX文件,但这就是全部。
If the requirement is to import only once then export from Money to csv or qif and process the exported files. Same applies to Quicken.
如果要求只导入一次,则从Money导出到csv或qif并处理导出的文件。同样适用于Quicken。
Money Sunset is free.
钱日落是免费的。
#4
If you are looking for a UK version, try http://www.microsoft.com/en-us/download/details.aspx?id=26915
如果您正在寻找英国版本,请尝试http://www.microsoft.com/en-us/download/details.aspx?id=26915
#5
This tool is free and will perform a more comprehensive export of Microsoft Money data. I don't think it can be used programatically though. http://www.ultrasoft.com/MoneyLink/overview.shtml
此工具是免费的,将执行更全面的Microsoft Money数据导出。我不认为它可以以编程方式使用。 http://www.ultrasoft.com/MoneyLink/overview.shtml