External data management

[eggpap]

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

 

[Martin Fishlock]

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.

 

[eggpap]

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

 

[Martin Fishlock]

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?