External data management

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eggpap - 23 Mar 2008 09:13 GMT

Hello,

Is it possible to connect a Microsoft Access table to manage it directly
from Excel
to get the data synchronized both in Excel and in Access?

Thanks, Emiliano

Reply to this Message

Martin Fishlock - 23 Mar 2008 11:22 GMT

Hi Emiliano:

It is possible to do this.

You build your database in access and get it working and then you use
querries to look at your data and soem vba to deal with adding and modifying
your data.

It may be easier just to keep the database in access and build the forms in
access.

Post a little more information and I will try and give some more advice.

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> Hello,
>
[quoted text clipped - 3 lines]
>
> Thanks, Emiliano

Reply to this Message

eggpap - 23 Mar 2008 12:06 GMT

Hello Martin,

you are very helpfull, but I don't know how to perform this function.
May I get a vba sample of management of one Access table by Excel ?

Emiliano

Signature

Se hai fretta non hai tempo
perché il tempo non ha fretta

Emiliano

> Hi Emiliano:
>
[quoted text clipped - 18 lines]
>>
>> Thanks, Emiliano

Reply to this Message

Martin Fishlock - 23 Mar 2008 14:03 GMT

Hi:
Have a look here for an example:

http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=8

It is quite complicated to do and not a trivial matter (done in a controlled
and secure way).

It depends on your data and how critical it is to the operation of the
organization.

There are also a number of books for excel database access - have a look in
your local library for help or search the web.

What are you actually trying to do?

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> Hello Martin,
>
[quoted text clipped - 25 lines]
> >>
> >> Thanks, Emiliano

Reply to this Message