>Hi all-
>I am new to automation. My job right now is to link Spss with a VFP application to allow the users to run regression analyses on the VFP data (brought into Spss using ODBC), and then write the results back to the VFP tables if the user wants to keep them.
>
>Spss is a fairly well documented ole automation server. The problem I have is that I don't know whether it's better to write a VFP component to be called from the spss end (via a menu item) to write the data back, or automate the process of getting the Spss results from the VFP end. Calling from Spss provides easier access to the results data, while calling from VFP obviously makes it easier to get at the VFP data.
>
>None of the field or table names are known in advance as they are all set up by the users.
>Carlie

Just an opinion - but I would start from the end that scores highest on the following criteria:
- you are most comfortable with from a programming perspective
- the end that is likely to have the most code in it
- the one that offers the greatest future flexibility
- if you need robustness (e.g. error handling) this might be better implemented from the vfp end.
- etc.

Personnally I think VFP makes a better Server than Client (in OLE Automation), so I would try to do everything with VFP in control.