|
#9
| |||
| |||
| Pick your reason(s): They don't view it as a requirement for the vast majority of Money users. The competition they are chasing doesn't do anything like that either. They are scared about what offering it would cost them in support. They don't think they could add it in a way that didn't make "brownout users" think Money was more "complicated" and "difficult to use" and "non-intuitive". "Bo Ossinger" <BoOssinger[at]discussions.microsoft.com> wrote in message news:64EFD787-7E08-4998-9544-87E4FFBCECC3[at]microsoft.com... - quote - > I could see that I could get much of the transaction data, but most > immediately I wanted more detail on accounts. Mostly I just want access > (pun > intended) to my own data, alas... MS has done so much with product > integration, I have to wonder why they missed the boat on this one. |
|
#8
| |||
| |||
| I could see that I could get much of the transaction data, but most immediately I wanted more detail on accounts. Mostly I just want access (pun intended) to my own data, alas... MS has done so much with product integration, I have to wonder why they missed the boat on this one. |
|
#7
| |||
| |||
| After a long time trying, I think it's hopeless. They just plain don't care about adding function at the "power user" end of the product. What data are you trying to export? I've been able to get most everything from the transactions and accounts except account (category, payee, classification, etc.) details, loan terms, flags, payee addresses (really that's just a payee detail), paycheck tab assignment for paycheck splits and schedule of the scheduled transactions. LP, DRP, and BP data are harder. I use customized reports and Export to Excel to get it to .CSV and then link Excel to the .CSV to import this stuff into a schema I've created. Note if you want the schema to be normalized, there is lots of work to do to flatten the data that comes out from Money via the reports. I wrote a lot of VBA to do this. Now I can normalize the entire transaction database including investments and loans. "Bo Ossinger" <BoOssinger[at]discussions.microsoft.com> wrote in message news:CA7C09FD-2C76-4B42-9629-B43DB685D92B[at]microsoft.com... - quote - > I unfortunately assumed that I'd be able to export from Money to an Access > database. I only want to pull data out so that I can generate my own > reports, but I can't believe that MS does not support that conversion. > I'd > settle for going through Excel to get there, but the MoneyLink utility > won't > even let me pick the data that I want to export. > How do we convince MS that this needs to be supported?... |
|
#6
| |||
| |||
| I unfortunately assumed that I'd be able to export from Money to an Access database. I only want to pull data out so that I can generate my own reports, but I can't believe that MS does not support that conversion. I'd settle for going through Excel to get there, but the MoneyLink utility won't even let me pick the data that I want to export. How do we convince MS that this needs to be supported?... |
|
#5
| |||
| |||
| In microsoft.public.money, GaryDave wrote: - quote - > I will also contact MS directly to see if there is any help there. But
Moneylink, from Ultrasoft, can read data from Money to Excel.> it seems clear from this newsgroup and other web research that I've > done that Money isn't very adaptable to VBA-type integration with other > Office programs, like Word/Access, or Excel/Access, automated > interfaces I have experience with and are used every day in our office. http://www.microsoft.com/money/customers.mspx has a link. |
|
#4
| |||
| |||
| Nope. GnuCash on Linux using MySql (I **vaguely recall** they support that as a back end) and the MySQL ODBC connection might get you there. GnuCash normally uses an XML data file format. You could probably get there that way as well. Of course, GnuCash implies Linux. "GaryDave" <garydave[at]hotmail.com> wrote in message news:1130305137.832334.174340[at]g44g2000cwa.googlegroups.com... - quote - > Dick - So Money is out. But do you - or anyone else reading this know > of a bookeeping program like Quicken/MS Money that can be > programmatically (VBA, etc.) linked to Access, in a way that would work > "on a production basis"? > Thanks for your useful replies. |
|
#3
| |||
| |||
| Dick - So Money is out. But do you - or anyone else reading this know of a bookeeping program like Quicken/MS Money that can be programmatically (VBA, etc.) linked to Access, in a way that would work "on a production basis"? Thanks for your useful replies. Gary |
|
#2
| |||
| |||
| They don't seem to think it's a legitimate requirement for Money users. There *are* ways you can fake it on a limited basis. MoneyLink, the QIF tools, and careful creation of Money reports then exported to CSV file which you can then link into Access can get some things done, but none of it easy and all of it tedious for any ongoing purpose. Lots of data in Money is just plain inaccessible programmatically. I've used reports to export Account data and account register data and a lot of VBA and cunning in Access to recreate the transaction database in Access in my own table design. But it was an experiment only--proof of concept that there COULD be a home-rolled life after Money--and surely not something you'd want to do on a production basis. "GaryDave" <garydave[at]hotmail.com> wrote in message news:1130282448.169916.174820[at]g49g2000cwa.googlegroups.com... - quote - > Thanks for your reply. It's too bad MS doesn't make it easier to > integrate their programs. In fact, it sounds like there is no way to > do what I would like to do: be able to exchange data between Money and > Access. There must be thousands of small businesses that have similar > issues - I wonder why this isn't being addressed. > I will also contact MS directly to see if there is any help there. But > it seems clear from this newsgroup and other web research that I've > done that Money isn't very adaptable to VBA-type integration with other > Office programs, like Word/Access, or Excel/Access, automated > interfaces I have experience with and are used every day in our office. |
|
#1
| |||
| |||
| Dick - Thanks for your reply. It's too bad MS doesn't make it easier to integrate their programs. In fact, it sounds like there is no way to do what I would like to do: be able to exchange data between Money and Access. There must be thousands of small businesses that have similar issues - I wonder why this isn't being addressed. I will also contact MS directly to see if there is any help there. But it seems clear from this newsgroup and other web research that I've done that Money isn't very adaptable to VBA-type integration with other Office programs, like Word/Access, or Excel/Access, automated interfaces I have experience with and are used every day in our office. Gary Dick Watson wrote: - quote - > See http://umpmfaq.info/faqdb.php?q=10 in specific and > http://umpmfaq.info/faqdb.php?cat=3 in general. > "GaryDave" <garydave[at]hotmail.com> wrote in message > news:1130165076.608412.19530[at]g43g2000cwa.googlegroups.com... > > I have a registration database for a school that uses MS Access. Our > > book keeper uses Quicken, so that all the student names, addresses, > > etc. needs to be entered twice. I am thinking of migrating the > > financial records to MS Money, so that we can do some VBA programming > > or the like to send student data from Access to Money. Does anyone > > know if this can be done, or have any experience doing this sort of > > thing? |
| | |||
| |||
| See http://umpmfaq.info/faqdb.php?q=10 in specific and http://umpmfaq.info/faqdb.php?cat=3 in general. "GaryDave" <garydave[at]hotmail.com> wrote in message news:1130165076.608412.19530[at]g43g2000cwa.googlegroups.com... - quote - > I have a registration database for a school that uses MS Access. Our > book keeper uses Quicken, so that all the student names, addresses, > etc. needs to be entered twice. I am thinking of migrating the > financial records to MS Money, so that we can do some VBA programming > or the like to send student data from Access to Money. Does anyone > know if this can be done, or have any experience doing this sort of > thing? |
|
#-1
| |||
| |||
| Greetings. I have a registration database for a school that uses MS Access. Our book keeper uses Quicken, so that all the student names, addresses, etc. needs to be entered twice. I am thinking of migrating the financial records to MS Money, so that we can do some VBA programming or the like to send student data from Access to Money. Does anyone know if this can be done, or have any experience doing this sort of thing? Thanks! Gary |
| Tags |
| access, linked, money |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Money 2003: Active Statement Linked to Wrong Account David Chandek-Stark: I have the Symptoms and Cause of the problem described in http://support.microsoft.com/default.aspx?scid=kb;en-us;190416 - except I am using Money... | Microsoft Money | 3 | 05-25-2005 08:17 PM | |
| Linked Transactions/downloads imscoop22@hotmail.com: I am new to MS Money 2004. Can someone please explain something to me... I have setup my accounts and have several with a particular bank:... | Microsoft Money | 1 | 12-31-2004 06:48 PM | |
| Money 2004 shows transactions to review for an online linked account, but none shown AC: Usually, when Money downloads transactions, they appear in my register as transactions I need to accept. However today, none of them are showing up... | Microsoft Money | 1 | 04-18-2004 02:14 PM | |
| Cross-linked accounts PuffinPete: I've had what I considered to be a corruption in Money 2000 and lived with it, but have just acquired Money 2004 and tried the following and it... | Microsoft Money | 5 | 03-03-2004 10:11 AM | |
| Thread Tools | |
| Display Modes | |
| |