Hi All,

I am after some advice, I need to output the contents of an access query to a new excel worksheet. I also need to generate a new worksheet for each new record I pull from the query I am using.

Does anyone have a sample of the best way to achieve this or able to offer any tips.

I am a vb developer but I don't do much with Access and Excel.

Any help or advice appreciated.