hi
in my excels iam using the external source

With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DRIVER={Microsoft ODBC for Oracle};UID=scott;PWD=tiger;SERVER=dev;" _
, Destination:=Range("A1"))
.CommandText = Array( _
"SELECT TELE.CALLING_DATE, TELE.CALLING_TIME, TELE.CALLED_NUMBER, TELE.DURATION, TELE.UNITS" & Chr(13) & "" & Chr(10)

& "FROM SCOTT.TELE TELE" _

-----
but i unable excute this query

SELECT TELE.CALLED_NUMBER, sum(TELE.DURATION) DURATION, sum(TELE.UNITS) UNITS
FROM SCOTT.TELE TELE
group by TELE.CALLED_NUMBER
order by DURATION,UNITS

error :: from caluse