×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

need q&A translation

need q&A translation

need q&A translation

(OP)
have old q&a datamanagement system that I need to move into the 21st Century.  Are there any free translation tools that could help me bring data into access or excel? thanks.

RE: need q&A translation

Another option might be to unload the data into flat files, either fixed length or delimited, then use a database load utility to load the data into the new database.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

RE: need q&A translation

(OP)
My problem is that the data sits not in a database but individual records.  Don't know how to view the records and then export into a flat file.  I need some software that will recognize these files, then convert to a txt or csv file.  help.

RE: need q&A translation

what kind of files?

RE: need q&A translation

(OP)
Each record appears to be in a separate folder whcih includes a pair of files: *.DTF and *.IDX - my guess is that the DTF is a form or structure file and te IDX is the data - but that's only a guess.  I found Symantec purchased Q&A many years ago and must have abandoned it.  I would luv to be able to convert each file in a data record, merge them, and then repurpose them.  Q&A does not appear to store data as a single database, but as a collection of folders, each containing data.

RE: need q&A translation

IDX is usually an index file and quick google of dtf shows that it's the database file for the Q&A software.  

In another forum it is indicated that you can export the Q&A files as a dbf and Access can import the data.  

I couldn't get the page to load, but cicorp.com apparently has converter that :

Quote:

We can export the data from any Q&A database in to popular programs such as ... Basic conversion converts all Q&A database fields as the same data type. ...

And I guess that this company has taken over on-going support of the Q&A products:
http://www.pcta-usa.com/qa.htm

HTH

Leslie

RE: need q&A translation

Have you tried opening the dtf files in notepad to see what the structrure is, or are they encrypted?

< M!ke >
Your right to an opinion does not obligate me to take you seriously.
- Winston Churchill

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close