Solved

Extract data from ACT! file

Posted on 2014-01-07
2
1,426 Views
Last Modified: 2014-01-24
I have some datafiles left over from an old version of ACT! for Web which our company used for a very brief time.  I would like to access the data but no longer have the software on my system.  
The files I have consist of Contacts.ADF, Contacts.ALF, Contacts.pad and a folder named Contacts-database files.

I would like to be able to extract the data into either MS Access, MY SQL or Excel.

How can I do this?  Can I use ODBC and if so, what drivers would I need and where can I source them.

Thanks
0
Comment
Question by:Nemetona
[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
2 Comments
 
LVL 37

Accepted Solution

by:
PatHartman earned 250 total points
ID: 39762865
Those are non-standard file types.  You will almost certainly need to reload the software in order to extract the data.

You could try opening the files with Notepad to see if the files are plain text.  If they are, you can get someone to recover the data for you if they can figure out the file format.  If you can't read your data with notepad, then the file format is proprietary.

It is possible that Act! offers ODBC drivers but you would have to get them from Act!  Perhaps you can get a trial version of the software that will allow you to open the files long enough to export them to some more standard format.
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 39767503
My understanding is that ACT! databases allow you to read data through standard ODBC/OLEDB connections, but in order to write data you must use the ACT! SDK. I'm not sure of the credentials you'd need to do this, but I believe those are SQL Server databases, so you'd need SQL Server installed. Look in that folder named "Contacts-database files" to see what you find there - but if it was web-based, then the data files were most likely stored on a server somewhere, and not your local desktop.

Also, if you're dealing with older data, or (as in your case) web-based data, you may not be able to use the ODBC/OLEDB methods. You may need to do as Pat suggests and reinstall the ACT! software and use the Export feature (assuming there is one).
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

751 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