>Hi,
>
>I'm writing an application that will call a COM that return a recordset as result. I need to use VFP to save the recordset into a table. Is there any quick method to do so?
>
>Ok, let me assume that I use the slowest method, i.e.
>- loop through each records in the recordset
>- add a new record to dbf
>- replace each value
>- update
>But I'm having problem accessing '.Value' for field with type adNumeric, I don't know what the problem is!
>
>Also, when I try to use Recordset's GetRows method, it will return error for some table, and it's error message is so general that I dunno what the problem is.
>
>Any expert with expeience on this?? Please help!!
>
>Thx!

GetRows() will choke on large result sets, besides VFP has a limit for the number of elements in an array. Either use VFPCOM as others suggest or consider doing your processing using the RS as is (depends on the kind of processing).