Hi All, I want to be able to create a Pivot table in excel using some fields in my ACT! 2006 db. I have a large number of fields in my db and it seems to have broken the data into 2 contacts fields VRP_CONTACT and VRP_CONTACTS_TABLE_1 I can import either table into excel, use them as a data source etc and they work fine individually. The problem is I need selected fields in both tables to create the Pivot table. I tried importing both into a Sheet but the data doesnt line up properly and there is no common field to link them. Any ideas would be great!