External data management
 

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

External data management
 

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.

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


"eggpap" wrote:

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

External data management
 

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

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

Emiliano
"Martin Fishlock" ha scritto nel
messaggio ...
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.

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


"eggpap" wrote:

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

External data management
 

Hi:
Have a look here for an example:

http://www.paragoncorporation.com/Ar...px?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?





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


"eggpap" wrote:

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

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

Emiliano
"Martin Fishlock" ha scritto nel
messaggio ...
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.

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


"eggpap" wrote:

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