Storing Data in Access Database...
 

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.

Storing Data in Access Database...
 

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.

Storing Data in Access Database...
 

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.

Storing Data in Access Database...
 

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.

Storing Data in Access Database...
 

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.

Storing Data in Access Database...
 

Su ACCESS really has two components, the end-user interface, the ACCESS
forms package and stuff like that, and the database engine itself (called
JET), which is what DAO/ADO talks to.

The database engine is installed by default on any modern PC (and if it isnt
you can download MDAC from microsoft for free and install it), so you dont
need ACCESS itself.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Ernst Guckel" wrote in message
...
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.