Writing to Excel

[LonnieJohnson]

I have a recordset that I would like to write as rows in an excel spreadsheet. I want to start on a certain line. The columns are already predefined and match my recordset. This will run each month so it will need to overwrite the prior month's data.

What is the best way to go about this?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[RoyVidar]

Then I'd say this sounds like an ideal match for the .copyfromrecordset method of the Excel Range object. Here's a sample thread705-949044

Roy-Vidar