Is there some way to merge access and excel?

[Wookerkitty]

I am trying to set up a DB that would allow me to list all the interpreters
working for a certain company, the clients they work for, and the places they
interpret. Is there a way to use calculations in ACESS that would allow me to
also have their hourly time figured and then added to an ongoing total for
billing or do I need to use Excell for that? Is there a way to merge Excel
and ACCESS in a way that would allow me to use info in ACCESS to fill in
cells in Excel automatically?
Office 2003

 

[Douglas J. Steele]

Calculations are fairly straight-forward to add to queries in Excel.

 

[John Vinson]

I am trying to set up a DB that would allow me to list all the interpreters
working for a certain company, the clients they work for, and the places they
interpret. Is there a way to use calculations in ACESS that would allow me to
also have their hourly time figured and then added to an ongoing total for
billing or do I need to use Excell for that? Is there a way to merge Excel
and ACCESS in a way that would allow me to use info in ACCESS to fill in
cells in Excel automatically?
Office 2003

You can do either. You should not attempt to put calculations in a
Table, but it's very straightforward to do even quite complex
calculations in a Query, a Form, or a Report (for the billing, I'd
suggest a report); it's also quite feasible (though a bit more
complex) to interface Access and Excel, using automation to put data
into Excel.

John W. Vinson[MVP]