Where can I find documentation on how to use a flat file (table) exported
from MS-Access to create a spreadsheet in Excel that contains subtotals?

e.g. I have an employee timesheet table with (3) columns: Department,
Employee and Hours. I need use this data to create a spreadsheet in Excel
that groups by department, lists each employee (and their hours) and then
subtotals the employee hours for each department - with a grand total.

The spreadsheet needs to be updated monthly and the number of employees by
department can vary.

1. ConThrough excel using MS query and then create a pivot....

http://office.microsoft.com/en-us/ex...CH062528421033

2. Create a report in access with grouping and export it as Excel.....


"JimP" wrote:

Where can I find documentation on how to use a flat file (table) exported
from MS-Access to create a spreadsheet in Excel that contains subtotals?

e.g. I have an employee timesheet table with (3) columns: Department,
Employee and Hours. I need use this data to create a spreadsheet in Excel
that groups by department, lists each employee (and their hours) and then
subtotals the employee hours for each department - with a grand total.

The spreadsheet needs to be updated monthly and the number of employees by
department can vary.

Thank you,

"Ritwik Shukla" wrote in message
...
1. ConThrough excel using MS query and then create a pivot....

http://office.microsoft.com/en-us/ex...CH062528421033

2. Create a report in access with grouping and export it as Excel.....


"JimP" wrote:

Where can I find documentation on how to use a flat file (table) exported
from MS-Access to create a spreadsheet in Excel that contains subtotals?

e.g. I have an employee timesheet table with (3) columns: Department,
Employee and Hours. I need use this data to create a spreadsheet in Excel
that groups by department, lists each employee (and their hours) and then
subtotals the employee hours for each department - with a grand total.

The spreadsheet needs to be updated monthly and the number of employees
by
department can vary.