Hi Mark,
Alexander placed in Downloads section file #
9944, which works much much faster than VFPXTab. I made few modifications in this program to support totaling option. It still could be improved a little bit, but I would suggest MS to take a look at this algorithm instead of the one, used in VFPXTab...
BTW, Valdis Matison has a similar program with even more options...
>John
>
>I have to disagree
>
>Excel does this job much faster. Perhaps you are factoring in the time it takes to load Excel and are only running on small tables.
>
>For large tables it is better to uses anything other than VFPXTAB
>
>
>>A particular case?? The cross-tabulation of data is a fairly generic process. I can't imagine a factor that would make a particular case unique. Perhaps the size of data. Then again, this would go back to the core design of the base program that would be useful in all situations.
>>
>>Sorry Alexander, I can't agree with your conclusion especially since you have offered no benchmarks to support your conclusion. To say that the program that ships with VFP cannot be slower is a conclusion that simply has no basis. I have used VFPXTAB on many occasions. I have also used Excel via automation for these tasks. Of the two, I'll take the VFP solution.
>>
>>
>>
>>
>>>Hi!
>>>
>>>>How about the one that ships with the product? VFPXTAB.PRG???
>>>
>>>It's as slow as only possible. Write your own program for particular case.
>>>It not very difficult but will be much faster.
>>>
>>>Alexander
If it's not broken, fix it until it is.
My Blog