| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exporting selected data from Access to Excel | Excel Discussion (Misc queries) | |||
| exporting data from access to excel | Excel Discussion (Misc queries) | |||
| Exporting data from access to excel | Excel Worksheet Functions | |||
| Need Excel macro for exporting data to Access | Excel Programming | |||
| Exporting Data from Excel to Access Problems | Excel Programming | |||
Threaded Mode
