Export ACT 4.0 to File

Posted on 2011-03-07
Last Modified: 2012-05-11
I know nothing about ACT but have been tasked with trying to take the data from an ACT 4.0 installation and importing it into an existing (but empty) MSSQL 2005 database.

I have seen a few references that say ACT can be exported to a text file which could be imported into MS Excel.  That file could then be imported into the database.  Problem is nothing indicated to which version(s) this applies to.

The data actually exists at an office out of the country so I only have access "through" another person who is there and will have to do whatever needs done in ACT and send it to me to configure and then send back.

I am find with the SQL and Excel part but need to know what to tell the person there as to what to do to get files for me.
Question by:darahood
  • 2
  • 2

Expert Comment

ID: 35059024

Author Comment

ID: 35060748
Thanks, but READ THE QUESTION!  I know sql and how to do the import.

I need to know how to get the data out of ACT

Expert Comment

ID: 35061770

Pls check this Symantic site :
this is the best site which has tutorials about Act-4 , search in this page about how to : Exporting Data from ACT! ...
i hope it helps,
Good luck,

Accepted Solution

wellous earned 500 total points
ID: 35061802
OR , download the manual from here :

BR, Wellous

Author Closing Comment

ID: 35062732
Thanks for the help!

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 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