Community
Showing results for 
Search instead for 
Do you mean 
Reply

Exporting Call Detail/Activity to Microsoft Access

New Member
Posts: 1
Country: USA

Exporting Call Detail/Activity to Microsoft Access

I am a consultant helping a friend of mine out who uses ACT 2008, along with his sales staff.  My client is wanting to combine call activity/details from 2-dozen sales reps, and potentiall import them into Access/SQL server to utilize a custom reporting system beyond Act's capabilities.  Can MS-Access import data from ACT?  Can it import data based on last access date?   Or can ACT export data in a txt delimited, comma, etc. so that access can import it?

 

thanks 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Exporting Call Detail/Activity to Microsoft Access

Possibly the easiest way is to have Access or the app you're using for reporting to read the ACT! data via OLEDB as per this ACT! Knowledge Base article - http://tinyurl.com/4qbmod