Hello All.
I'm using this code to connect to a VFP dbatabase from Excel :

		oPivotCache.Connection = "OLEDB;Provider=vfpoledb;data source=" + DATAPATH
		oPivotCache.Commandtext = "select * from z"+tmpdbc
		oPivotTable = oPivotCache.CreatePivotTable( oTargetRange, "PivotTable" )
			

But, as we all know, this doesn't work in windows 64 bits. Do you know of any work around for thi>
Regars