Is there some way to merge access and excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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]
 
Back
Top