Msquery import to Excel

[MIKElaw]

Data into Excel via MSquery from ODBC

I have
A 1 2 4 5 6 7
B 1 1 1 1 1 1
B 1 2 2 2 2 3
C 1 1 1 1 1 1

what I need in Excel is
A 1 2 4 5 6 7
B 2 3 3 3 3 4
C 1 1 1 1 1 1

In other words sum all columns if the first col are the same
Am repairing someone else's work from 4-5 years ago and not very used to MsQuery but generally Ok on SQL

 

[SkipVought]

You'll need SQL something like this, a you have NO HEADINGS...
[tt]
Select
F1
, SUM(F2)
, SUM(F3)
, SUM(F4)
, SUM(F5)
, SUM(F6)
, SUM(F7)
From [YourSheetName$]
Group By F1
[/tt]
If you want no headings in the QueryTable results, Data > Data Range Properties has a checkbox to control that.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}