03-20-2009 11:01 AM
I have downloaded Contact and Contact Opportunities to Excel through ACT's OLEDB interface. Now, how do I release a Contact Opportunity to the Contact? Contact is not a field that is downloaded in the Contact Opportunity entries.
03-26-2009 03:01 AM
Yeah I have had this problem with Excel as well in that Excel for some reason strips out the ID Fields for each view and so it is not possible to create Joins etc between view tables!
The way I got around this was by using a trustware product called Report Genie which allows you create your SQL script and output to Excel using the ACT! OLEDB.