Solved

ACT to EXCEL

Posted on 2011-03-09
13
739 Views
Last Modified: 2012-05-11
Hi,

We just purchased ACT premium.  Is there a way to export Contact, Groups Company, Notes, History, Activity, Sales to Excel?  thx
0
Comment
Question by:mcrmg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 250 total points
ID: 35085056
Contacts, Groups and Companies are easy enough... but Notes, Histories and Activities have fields that are usually to large for Excel.

For different options to import and export to ACT!, have a look at:
http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html
0
 

Author Comment

by:mcrmg
ID: 35085338
I saw this one also, http://www.jltechnical.com/exporter.htm,
which one is better, any ideas? thanks
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35085398
Six of one, half a doz of the other.... I use itExport and know it better
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:mcrmg
ID: 35085567
I see, so itExport can support the latest version of ACT>?  thanks
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35085608
Yes. BTW: What are you trying to export to?
0
 

Author Comment

by:mcrmg
ID: 35085619
Excel  thanks
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35085641
Why would you want it in Excel?

You do realise that Excel has limits in it's field size and number that ACT! doesn't? It's unlikely to fully read the Notes/History because of this
0
 

Author Comment

by:mcrmg
ID: 35085677
with office 2007, the row should be enough for what we have.  Can itExport do Excel?  thanks
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35085815
It's the field size that's the big problem.

itExport saves in CSV, which can then be opened in Excel.... if the Notes/history fields aren't to large
0
 

Author Comment

by:mcrmg
ID: 35085936
thank you
0
 

Author Comment

by:mcrmg
ID: 35085943
by the way, where should I install itExport, local or server?  thanks
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35086218
Usually best to have them where the database is ... less network traffic
0
 

Author Comment

by:mcrmg
ID: 35086224
ok. thx
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Introduction to Processes
Starting up a Project

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question