--As an example:
--first, i create the stored procedure...
CREATE PROCEDURE [dbo.].[sp_DAILYSALES]
@Cod_Forn int,
@cod_Familia int
AS
BEGIN
insert into openrowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test.xls;',
'SELECT cod_artigo,qtd,tpvp FROM [Sheet1$]')
select distinct cod_artigo,
sum(qtd) as qtd,
sum(tpvp) as tpvp
from Daily_Sales
where (Cod_Forn=@Cod_Forn)
and (Cod_Familia=@Cod_Familia)
group by...