Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #9  
Old 01-14-2006, 05:17 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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  
Old 01-14-2006, 05:09 PM
Bo Ossinger
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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  
Old 01-14-2006, 04:00 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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  
Old 01-14-2006, 03:07 PM
Bo Ossinger
Guest
 
Posts: n/a
Default RE: Has anyone linked MS Access and MS Money?

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  
Old 10-26-2005, 01:48 PM
Cal Learner
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

In microsoft.public.money, GaryDave wrote:

- quote -

> 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.


Moneylink, from Ultrasoft, can read data from Money to Excel.
http://www.microsoft.com/money/customers.mspx has a link.
  #4  
Old 10-26-2005, 12:15 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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  
Old 10-26-2005, 05:38 AM
GaryDave
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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  
Old 10-26-2005, 03:05 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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  
Old 10-25-2005, 11:20 PM
GaryDave
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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?


 
Old 10-25-2005, 02:37 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Has anyone linked MS Access and MS Money?

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  
Old 10-24-2005, 02:44 PM
GaryDave
Guest
 
Posts: n/a
Default Has anyone linked MS Access and MS Money?

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 02:02 PM.