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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05