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

M

MrB4477

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.
 
J

JimS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top