Can an Access accounting database be linked to a bank account?

Can an Access accounting database be linked to a bank account?

Post by T3ds » Sat, 10 Apr 2010 20:14:01


Is it possible for an Access accounting database to be linked to a bank
account, so that the company can see when payments are paid in?

Thanks for any replies.
 
 
 

Can an Access accounting database be linked to a bank account?

Post by Tom van St » Sat, 10 Apr 2010 23:14:45

On Fri, 9 Apr 2010 04:14:01 -0700, Owl < XXXX@XXXXX.COM >


Maybe. You'll need to talk to your bank. Some may have this
information available, for example as a Web Service. The bank would be
able to give you the details. Don't expect them to have VBA examples,
but they will likely have .NET examples or at least the spec itself.

-Tom.
Microsoft Access MVP

 
 
 

Can an Access accounting database be linked to a bank account?

Post by T3ds » Sun, 11 Apr 2010 07:19:01

Thank you for your very informative reply. Now, I know where to begin.
However, could you please tell me a little bit more.

If i get the .NET examples, or the spec itself, is it then a case of
converting that into VBA?

If that is the case, I know I won't be able to get very far with that on my
own. However, I am hoping that some kind person here will be able to help me
with that.

Thank you again, in anticipation of your reply.
 
 
 

Can an Access accounting database be linked to a bank account?

Post by Tom van St » Sun, 11 Apr 2010 13:54:12

On Fri, 9 Apr 2010 15:19:01 -0700, Owl < XXXX@XXXXX.COM >


Yep.
Assistance in the newsgroups for a project like this may be asking a
bit too much. What most of us would be impressed with is if you put in
your best effort yourself, and ask pointed questions that fit the
newsgroup format. You can't really expect help if all you offer is
"here is the 50-page spec - how do I write my program?"

Additional help may be on the web in general: for example people have
written about how to call a SOAP method from VBA.

Of course you can also hire the talent to help you with this part of
your project, up to the point you can take it further yourself.

-Tom.
Microsoft Access MVP
 
 
 

Can an Access accounting database be linked to a bank account?

Post by T3ds » Mon, 12 Apr 2010 05:47:01

ou have misunderstood me entirely, as you will see if you read what I wrote.

I merely started by asking if it is possible, as I don want to embark on a
project if it is impossible to do it in Access.

Then I asked for help with understanding your answer.

Then I expressed the hope, that if I did, in the future, embark on such a
project - that I could ask for help at the time (and there is nothing in what
I typed to indicate that what I would have asked would not be pointed
specific questions as they arose).

I cannot begin to imagine where you got the idea that I was eally
expecting help if all I offer is ere is the 50-page spec how do I write
my program?€
And, for that matter, you gave me no indication as to whether the spec would
be 3 sentences or 50 pages, so how would I know that 50 pages is possible?

I would have thought that the words, ow I know where to beginand the
pointed question I asked, being f I get the .NET examples or the spec
itself, is it then a case of converting it into VBA?(which, pointed
question, you didn answer, by the way) would alert you to my lack of bad
nettitude.

If you read all my posts in this thread and any other posts, you will see
that I have treated all responders with the utmost respect, and that all my
questions are pointed, specific questions and I have been grateful for all
help given, whether it has helped or not. You will also see that nobody on
Microsoft Discussions has ever spoken to me like this before.

I do not understand where your response has come from.


"Tom van Stiphout" wrote>

> On Fri, 9 Apr 2010 15:19:01 -0700,<Owl < XXXX@XXXXX.COM >.c>m>
> wro>e: >>
> Y>p.
> Assistance in the newsgroups for a project like this may be askin> a
> bit too much. What most of us would be impressed with is if you put>in
> your best effort yourself, and ask pointed questions that fit >he
> newsgroup format. You can't really expect help if all you offer>is
> "here is the 50-page spec - how do I write my progra>?" >>
> Additional help may be on the web in general: for example people h>ve
> written about how to call a SOAP method from V>A. >>
> Of course you can also hire the talent to help you with this part>of
> your project, up to the point you can take it further yourse>f. >>
> -T>m.
> Microsoft Access >VP >> >> >>>
> >Thank you for your very informative reply. Now, I know where to begin> >
> >However, could you please tell me a little bit more> >
> >If i get the .NET examples, or the spec itself, is it then a case >f>
> >converting that into VBA> >
> >If that is the case, I know I won't be able to get very far with that on >y>
> >own. However, I am hoping that some kind person here will be able to help >e>
> >with th>t>
> >Thank you again, in anticipation of your rep>y>
> >"Tom van Stiphout" wro>e>
> >> On Fri, 9 Apr 2010 04:14:01 -0700,<Owl < XXXX@XXXXX.COM >.c>m>> > >> wro>e>> > >>>> > >> Maybe. You'll need to talk to your bank. Some may have t>i>> > >> information available, for example as a Web Service. The bank would>b>> > >> able to give you the details. Don't expect them to have VBA exampl>s>> > >> but they will likely have .NET examples or at least the spec itse>f>> > >>>> > >> -T>m>> >
 
 
 

Can an Access accounting database be linked to a bank account?

Post by davi » Wed, 14 Apr 2010 17:13:19

You download the bank statement, as a CSV file.
(Often called an 'excel' file).

Then you import the bank statement into your accounting
database.

You can automate this process so that it happens
automatically.

You will need an experienced Access or Excel developer to do this if you
want it to happen automatically.

(david)
 
 
 

Can an Access accounting database be linked to a bank account?

Post by T3ds » Thu, 22 Apr 2010 23:40:01

Thank you very much for this information, David.