Jim -----

Clarify a bit, please? If you mean access Excel from VFP, that's one thing (best served by Automation) But to view VFP data *in* Excel, the easiest thing to do is just go to VFP, use the table, and COPY TO {filename} TYPE XLS to create an Excel worksheet from the data and go to Excel and load it.


>I apologize if this is the wrong Category for this question. Please advise me if it is.
>
>What is the best way to access a VFP DB from Excel:
> 1. Setup VFP app as an Automation Server?
> 2. Use ODBC connection?
>
>Can anyone provide or point me to sample code for both cases?
>
>TIA,
>jmu