Dear Moore,

Thank you for your reply. I type all command on the VFP command window. It can retrieve the data when I create ADO connection and recordset directly. So I don't know what's problem ? Can you suggest some site or book to tell me more about COM and ADO with VFP? Thanks a lot .... ^_^

Best Regards,

Justy Chow