Exporting Data from MS-Access to Excel
 

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.

Exporting Data from MS-Access to Excel
 

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.

Exporting Data from MS-Access to Excel
 

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.