How to combine records from Excel into totals in Access?

[tommyGibson]

How do I go from:

Client AAA 7 widgets
Client AAA 3 widgets
Client AAA 4 widgets
Client BBB 5 widgets
Client BBB 4 widgets

in Excel to:

Client AAA 14 widgets
Client BBB 9 widgets

in Access?


Any help = greatly appreciated!

[ADezii]

1. Assuming that you have a Spreadsheet that looks like:
   

   Name    Amount
   AAA       7
   AAA       3
   AAA       4
   BBB       5
   BBB       4
    

2. Link to the Excel Spreadsheet, and assuming you Name the Link Sheet1, execute bthe following Query:
   

   SELECT Sheet1.Name, Sum(Sheet1.Amount) AS [Total Widgets]
   FROM Sheet1
   GROUP BY Sheet1.Name;
    

3. the results will now be:
   

   Name    Total Widgets
   AAA          14
   BBB           9