Solved

Extract data from ACT! file

Posted on 2014-01-07
2
1,341 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
2 Comments
 
LVL 34

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now