import values from access, get sum of values, return in excel?

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

Guest

i need to know how do I select certain values from a database, total the sum
of those values and then return that sum to a specific cell in excel.
 
You can create the summary query in Access, then refer to that query in
Excel. Go to the cell and [Data]-[Import Database Query]...If the query
returns one cell only, that'll work.
 
Back
Top