Hi

It seems that you have posted the question in other newsgroup.
Someone has replied to you.

Also I think you may try to write a VB6 application which will do the same
job and the code will be similar. That is called automation.
295646 How To Transfer Data from ADO Data Source to Excel with ADO
http://support.microsoft.com/default...b;EN-US;295646


Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.