need to convert summary table to database table?
ok here is the trick...
1. open excel
2. Data -> Pivote Table and PivotChartReport
3. Multiple consolidation ranges option > Next
4. choose the I will create the page fields > Next
5. add >(summary table range)
6. select a location
7. click Layout button
8. Drag both the Column button and Row button away from the diagram.
9. ok > finish
(you will get small pivote table with sum of all values.)
10.Double click the cell containing total
(Excel will create a new sheet that displays the original data in the form of a database table)
more tips can be found
here