Calling Access Data into Excel Loop Question

[twoplustwo]

I have been given a procedure from the development team that calls a price from a secure database.

I pass three variable to the sub (forcast, settlement date and period number for a given half-hour).

I need to loop through each record in the data and print out the results to a new worksheet. Does anyone have any guidance on doing this?

Here is an example of the data:

SettDate ForDate P1 P2 P3
31/03/2008 31/03/2008 -3166- 3166 0
30/03/2008 30/03/2008 -2959 -3159 -2534

I need to store the each date in a row then move through each period.

If anyone could give me a point in the right direction I would be eternally grateful!

 

[Premy]

Well, it's not very clear what you're trying to do; could u be more elaborate?