Input data from access to excel

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

Guest

Our office personnel is looking for a way to use information from an access
query so the information is calculated in excel for easy use for everyone.
We are calculating data only; however, we will be using several different
calucations from different fields in the query. (Any help in the initial
set-up would be most appreciated, do I first need to create the worksheet in
excel?)
 
hi,
in excel use microsoft query.
tools>get external data>new database query.
Follow the wizards instructions. link to the access query.
This will create a downloadable querytable in excel that
can be refreshed at will by clicking the ! icon.
you wont be able to put formulas inside the querytable
(causes refresh errors) but you can put formulas to the
right of the querytable.
 
Back
Top