import - 如何使用.NET读取Microsoft Money数据文件？

Question

我需要从MS Money数据文件中读取和导入数据。我怎样才能做到这一点？有没有可用的SDK？

我也希望有一种类似的机制来读取Quicken文件。

Answer 1

随着Microsoft停止使用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

1. Get FileBinReplace utility here http://www.softtreetech.com/24x7/script.htm
2. Run it as FileBinReplace *.mny "MSISAM Database" "Standard Jet DB"
3. Rename *.mny to *.mdb
4. Use AccessFIX tool ($300; search the web for a download link) to repair the MDB file.

Query TRN and TRN_INVOICE tables as needed.

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)

我希望，由于MS不再支持产品或数据文件格式，因此他们将发布数据文件规范，以便可以创建工具来正确导出现有数据。

这也是一个SourceForge项目，用于以其他格式导出MsMoney数据: http://sunriise.sourceforge.net/