[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ACT to EXCEL

Posted on 2011-03-09
13
Medium Priority
?
749 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
  • 7
  • 6
13 Comments
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 1000 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
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Progress
Starting up a Project
Suggested Courses

864 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