Record per worksheet Access to Excel

[dagoose]

Hi All,

I am moving information from an Access query to an Excel worksheet. What I need is for each record from the query to be placed on a new worksheet within the workbook.

Any help appreciated.

dagoose

[salvelinus]

This might be dumb, I don't use Excel.
Wouldn't code along these lines work? This is pseudo code.

For i = 0 to  Access recordset upperbound - 1
   dim new excel worksheet
   put in recordset info
Next

Anyway, make a loop that creates a new excel worksheet and put the info in. Maybe a While type loop would be better.
Just as a place to start. Not sure what the limit is to the number of Excel worksheets, you may want to add a check for that.

[dagoose]

many thanks'

will give it a go. I haven't done that much with excel (vb6 normally) so I was unsure if I was approaching the problem in the correct way.

Cheers