A
AZSteve
I have two Access queries set up for two tables in an employee database at a
network location. Each prompts for an employee ID and returns one number - a
sum of the employee's data in the particular table. With up to 20 Employees
in each spreadsheet, we could import up to 40 sums (presently 40 separate
queries).
The data will not end up in an Excel table. In Excel each employee's info
is in an area 25 rows x 15 columns on the same sheet, with the employee ID
and two pieces of imported data in the same relative cells in each of the 20
employee areas.
This import will be done daily as part of a macro and formulas processing
purely Excel data. This is my first foray into importing data into Excel
from Access. What is the best way to get this info into those Excel cells?
Importing the data into a separate Excel table having the employee ID as the
leftmost field, then using formulas in those 40 cells to grab the applicable
data from the table? Importing the data directly into those 40 cells through
an Excel macro? Another way? So far the "importing data" help I have found
has been mostly getting data directly from an Access table to an Excel table,
and not through queries that return info as I described in the first
paragraph.
network location. Each prompts for an employee ID and returns one number - a
sum of the employee's data in the particular table. With up to 20 Employees
in each spreadsheet, we could import up to 40 sums (presently 40 separate
queries).
The data will not end up in an Excel table. In Excel each employee's info
is in an area 25 rows x 15 columns on the same sheet, with the employee ID
and two pieces of imported data in the same relative cells in each of the 20
employee areas.
This import will be done daily as part of a macro and formulas processing
purely Excel data. This is my first foray into importing data into Excel
from Access. What is the best way to get this info into those Excel cells?
Importing the data into a separate Excel table having the employee ID as the
leftmost field, then using formulas in those 40 cells to grab the applicable
data from the table? Importing the data directly into those 40 cells through
an Excel macro? Another way? So far the "importing data" help I have found
has been mostly getting data directly from an Access table to an Excel table,
and not through queries that return info as I described in the first
paragraph.