Community
Showing results for 
Search instead for 
Do you mean 
Reply

Excel Pivot table with 2 COntacts tables in ACT CONTACTS_TABLE_1

New Member
Posts: 1
Country: USA

Excel Pivot table with 2 COntacts tables in ACT CONTACTS_TABLE_1

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!
New Member
Posts: 3
Country: USA

Re: Excel Pivot table with 2 COntacts tables in ACT CONTACTS_TABLE_1

[ Edited ]
I have the same issue... Maybe I just do not understand how all this is layed out, but I would have thought this would be a large topic...
 
Anyone have any ideas?
 
Thanks
Cavall


Message Edited by Cavall on 02-19-2008 05:01 PM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Excel Pivot table with 2 COntacts tables in ACT CONTACTS_TABLE_1

You might try having Excel pull the data you want directly from ACT! via the OLEDB interface as per this ACT! Knowledge Base article - http://tinyurl.com/yphoko