Anybody here ever used VFP with excel 2010 and power pivot?

What should I know before starting to explore Power Pivot?

Denis, inside PowerPivot, there is an option to retrieve data from other data sources, which includes data from OLE/ODBC drivers.

Assuming your databases aren't huge, you might want to consider upsizing Fox data to SQL Server before using PowerPivot....but either way, you can use PowerPivot to "mash up" (as people often say) data from different sources.