Extend a report engine in Excel 2007 with VBA and storeprocedures?

[skyltar]

Hi

I amestimating to Extend a business system report engine in Excel 2007 with VBA and storeprocedures. My thought is that my Business system (ERP) has a key fields that isexported out into the Excel sheet but I am missing 5 fields in this particular report. This fields cannot be inserted by the standard report engine so I thought a buttonin Excel 2007 wil do the trick. So my question is wich oneof folloowing suggested approacheswill be the best out of a performance view:

1) A macro that iterates through the existing data in the Excel worksheet to get the key Identities so that a stored procedure can be run for every one af the rows in the excel sheet and add the 5 missing fields

2) Extract a big dataset from db instead of having a store procedure being executed for each and every row in the excel sheet. This dataset will then in turn be iterated by the macro so the missing 5 fields can be put ineach correct row by the macro

3) any other suggestions?