Ok... One more thing... Is there a way to include this spreadsheet on a
system that does not have Access installed?

Thanks,
Ernst.


"Jim Thomlinson" wrote:

You will need to be reasonably proficient with VBA to do this. You want to
read up as much as you can on ADO Recordsets. What you wnat to do is very
possible but not very easy...

"Ernst Guckel" wrote:

I am lookin gto add data to the database, update current data and retrieve
existing data from the database.

Ernst.


"Jim Thomlinson" wrote:

Are you only intending to retrieve the data out out Access or did you want
the abiblity to write back to the database. It makes a big difference in
terms of the complexity. You can read from the database using MS Query or
even a pivot table. To write back, now you have to get into ADO recordsets
and a whole bunch of code...

"Ernst Guckel" wrote:

Hello,

I have been using excel for a few years now and my employer uses excel
spreadsheets for their data. I would like to store the data in an access
database and the interface in excel. Can anyone suggest reading material on
how to do this or point me in the right direction?

Thanks,
Ernst.