I am not sure of the best way to approach this task...

I have an excel calcuator that I created . It consists of 4 sheets of
calculations with common data referenced from the first worksheet.

I am creating a database which would contain fields for the information
calculated in the calculator.....which would use the data in reports etc...
what is the best way to develop this....

Should I be doing all this in access with calculated fields and forms ......
OR
What is the best way to incorporate the Excel calculator
Are there advantage / disadvantages to the choices...

Any advise or even better a link to a downloadable example of the best way
to approach this would be great...Thanks

I'd put the data in Access. If there needs to be a reference between
columns, an Access query can easily handle the calculations. OTOH, if there
are references to a particular cell or more than 1 of them, you can either
do it with public variables or through Excel automation. I prefer using
automation because my users can see and understand what's going on. Have a
look at the following web page to see an Example of automation. In your case
you will want to open an Excel template (.xlt) if there are specific
calculations that have defined formulas:

http://www.mvps.org/access/modules/mdl0006.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"Dermot" <(E-Mail Removed)> wrote in message
news:ECDA0399-0A76-4BED-A5FA-(E-Mail Removed)...
> I am not sure of the best way to approach this task...
>
> I have an excel calcuator that I created . It consists of 4 sheets of
> calculations with common data referenced from the first worksheet.
>
> I am creating a database which would contain fields for the information
> calculated in the calculator.....which would use the data in reports
etc...
> what is the best way to develop this....
>
> Should I be doing all this in access with calculated fields and forms
.......
> OR
> What is the best way to incorporate the Excel calculator
> Are there advantage / disadvantages to the choices...
>
> Any advise or even better a link to a downloadable example of the best way
> to approach this would be great...Thanks
>
>
>

Thanks for the help and link Arvin
Regards
Dermot

"Arvin Meyer [MVP]" wrote:

> I'd put the data in Access. If there needs to be a reference between
> columns, an Access query can easily handle the calculations. OTOH, if there
> are references to a particular cell or more than 1 of them, you can either
> do it with public variables or through Excel automation. I prefer using
> automation because my users can see and understand what's going on. Have a
> look at the following web page to see an Example of automation. In your case
> you will want to open an Excel template (.xlt) if there are specific
> calculations that have defined formulas:
>
> http://www.mvps.org/access/modules/mdl0006.htm
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "Dermot" <(E-Mail Removed)> wrote in message
> news:ECDA0399-0A76-4BED-A5FA-(E-Mail Removed)...
> > I am not sure of the best way to approach this task...
> >
> > I have an excel calcuator that I created . It consists of 4 sheets of
> > calculations with common data referenced from the first worksheet.
> >
> > I am creating a database which would contain fields for the information
> > calculated in the calculator.....which would use the data in reports
> etc...
> > what is the best way to develop this....
> >
> > Should I be doing all this in access with calculated fields and forms
> .......
> > OR
> > What is the best way to incorporate the Excel calculator
> > Are there advantage / disadvantages to the choices...
> >
> > Any advise or even better a link to a downloadable example of the best way
> > to approach this would be great...Thanks
> >
> >
> >
>
>
>