Hello.

I was using this code to create a pivot table from a free vfp table:

oPivotCache.Connection ="OLEDB; Provider=vfpoledb.1;datasource ="+DATAPATH

It worked very well with afree table. But now I need to connect to a database table wich have long field names. In this case, he connection string does not work, does anyone managed to connect Excel 2010 to a Database VFP Table?

Thanks in advance