Database is VFP

I can do whatever excel can control.

Problem with a stored proc is that the data is normaly provided by a bunch of CA's and I feel a bit uncomfortable with the same code on two places

Also stored proce needs to change the DBC on changes on the SELECT - something I was happy the get rid of with CA's

Lutz
>Can you make a single call to a Stored Proc?
>
>
>>Hi,
>>
>>customer comes up with a problem.
>>
>>they are simple incapable of working with a mamaged database. hey have a scenario where the requirements change faster then one can can code and test and the requirements of one day are just valid those day. So they use a mess of Excel files to get there mangares the answers of the moment.
>>
>>We have given up to try to put it in the database - it does not make sense.
>>
>>But they use, for there general problems, a database system. Now they like to base there Excel stuff on this data. This is a system with one database per project.
>>
>>So the idea was to make the data from the database available for Excel.
>>
>>The data can not be read by one SELECT SQL command, at least in VFP - VFP will run into C0..05 problems.
>>
>>What would the be best way to provide the data?
>>
>>Thanks for your help
>>
>>Lutz