mr_anusorn
asked on
Export a DAO recordset to excel?
How to easily export a DAO recordset to EXCEL within a few line of code?
http://support.microsoft.com/support/kb/articles/q172/0/58.asp?FR=0
Use the CopyFromRecordset method.
gobjExcel.Sheets("Budget") .Range("E1 0").CopyFr omRecordse t rst
gobjExcel.Sheets("Budget")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Transfert you recordset into a array.
After you can directly transfer you array into Excell
After you can directly transfer you array into Excell