>If Excel2002 or later:
>-Create a new text file
>-Rename file to something with a udl extension. ie: myDataLink.udl
>-Dblclick the file
>-Select first tab of dialog and select VFPOLEDB there, select your dbc in second tab
>-In excel from menu Data\External data\Import data
>(select files of type udl)
>-Point to your udl file
>-Tables would be listed. Select (it's direct table. If you want you can set to SQL and give and write SQL there).
>
>If earlier then the udl is missing from menu (learned in last few days). Create and run a macro then. ie:
>
>

>strCon = "OLEDB;Provider=VFPOLEDB;Data Source=c:\mypath\mydbc.dbc"
>strSQL = "select * from myTable"
>
>ActiveSheet.QueryTables.Add( _
> Connection:=strCon, _
> Destination:= range("A1"), _
> SQL := strSQL ).Refresh
>

>PS: You can save excel file as XML and play with contents using any editor (then next time you'd simply open edited version from excel).
>Cetin

Excelent! Thank you.