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

x
?
Solved

Export ACT 4.0 to File

Posted on 2011-03-07
5
Medium Priority
?
594 Views
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.
0
Comment
Question by:darahood
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:Amgad_Consulting_Co
ID: 35059024
0
 

Author Comment

by:darahood
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
0
 
LVL 5

Expert Comment

by:wellous
ID: 35061770
Darahood,

Pls check this Symantic site :
http://www.vtc.com/products/Symantec-Act-4-tutorials.htm
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,
Wellous
0
 
LVL 5

Accepted Solution

by:
wellous earned 2000 total points
ID: 35061802
OR , download the manual from here : http://www.ufaa2.com/NewTechSite/Downloads/ActDownloads.html

BR, Wellous
0
 

Author Closing Comment

by:darahood
ID: 35062732
Thanks for the help!
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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

825 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