odbc.jpg (1207 bytes) QAConvert.com Q&A.jpg (1273 bytes)

Converting to and from Symantec Q&A

accessconvert.jpg (6281 bytes)

We specialize in getting ALL the details from one database format into another. 
So you don't have to re-enter any data.
We have years of experience doing projects with
Symantec Q&A

 Supporting the products of
 Symantec.com/Q&A

We support you, even though Microsoft Windows 10 no longer supports Q&A.
Nor does Symantec.  You can use Oracle Virtual Box to run Q&A on Windows 7.

Standard Fees

How to determine the number of records

Q&A MAIN MENU
Select F - File
S - Search
Select your DTF file
Enter Password if it has one
Retrieve Spec - F10 -Continue
Look at the bottom of the screen for the count

Total Forms = number of records

Send both your .DTF & .IDX file(s) via
email to Convert@CICorp.com

Or, if it is a large file, then go to https://WeTransfer.com
Select the file such as "MyDatabase.zip"
Send to Convert@CICorp.com
Enter your email address at your company
Message is optional, such as a password if necessary
click Transfer

 

Database Export and Conversion Services

We can export the data from any Q&A database in to popular programs such as Microsoft Access, Excel, ACT!, Goldmine, and Salesforce.com.

Just send send us the database, we perform the conversion, then send you the finished file.  Please remember that each Q&A database consists of a two files that work as a pair, the .DTF plus the .IDX file.

We make Memo or Notes fields for the lengthy text passages at no additional charge.

Basic conversion converts all Q&A database fields as the same data type.  These types are Text, Number, Date, and Yes/No fields. 

You will need to provide us with the administrative UserID and Password so we can open the file and do the conversion.

To send your files, just use our form at DataUpload.com

For an additional charge, we will perform a thorough pre-conversion evaluation of your Q&A database. This will expose any potential "problem" areas that might adversely affect the conversion result, such as corruption in the database or expanded fields containing lengthy text values like notes or comments that require special handling.

During our post-conversion check, we sample the records in the converted database and compare them with the same records in the Q&A database to ensure that the conversion process correctly transferred the data.

For conversions to Access 2000, we can usually retain your original Q&A database's field names in the converted database. (Q&A supports lengthy field names that can contain spaces.) There is no additional charge for this.  A field such as "First Name" would become "First_Name" for example.

We can handle the tough conversions

Many conversions from Q&A are relatively simple.  But we have done hundreds of them and can handle the toughest data conversions.  One of the challenges of a Q&A conversion comes from the fact that Q&A is so flexible in how it stores data.  In some ways, this 1984 program has more capabilities than the most modern Microsoft Access!  For example, while Access is limited to 254 fields per record, Q&A can have 16000 fields!   While Access requires a unique field name, Q&A can re-use the same name, and even no name at all for a field! 

However Q&A is an old, flat-file database, that is not truly relational.  So the advantages of converting outweigh its features.  That's why Q&A is no longer in business and why most people use Access.  So we have developed procedures to split up the data in to multiple tables, which is actually better organized.  Often, a Q&A had so many fields (columns) which really should be records (rows).  So you will end up with a much better designed, relational database, that allows you to do more with the data.

Videos


Our Pricing

Our fees are based on the number of records in your database.  We will give you an estimate in advance.  We accept checks either sent by overnight, or via check services like www.Qhex.com.  We can also accept major credit cards from repeat customers.

For each database, tell us how many forms (records)  are in it.  Let us know how many fields (categories of information like First name, Zip code, etc.)  These affect the price.

Possible Additional Charges

For an additional charge, we can also design a Data Entry/Record Search form for your new database that looks and works like the form in your Q&A database.

Q&A for Windows databases can contain multiple forms, such as a Master form, a Main Menu form, an input form and one or more search forms. The database might also contain scripts which link the forms into a kind of application. If you have a Q&A for Windows application like this, we can re-create it in Access for you at an additional charge.  Special field qualities such as formatting, field validation, initial values, reports, programming, field restrictions, and lookups would be an additional charge..

Reports and database customization features such as Programming, Saved Specs, Restrict Values, Initial Values, Field Templates, and Speedy Fields can also be done for an additional charge.

If you have been having problems with the database such as missing data, reports that won't run, intermittent or regular error messages when performing certain operations, or the like, you must inform us in advance.  We would have the same experience, and may be able to fix the database first, for an additional charge.

We must actually see the Q&A database in order to fully evaluate it and give you a firm quote.  The prepaid charge for this pre-conversion evaluation is $60 for up to three databases as it does take our time from other projects to do so.  If you then have us perform the work, the pre-conversion evaluation charge will be deducted from our overall charges.


Screen Design

Most people convert to Microsoft Access or ACT!   We can create screens which contain the fields the way you are used to seeing them in Q&A - with many enhancements.  The cost for this would be hourly, and depends on how fancy a screen you would like.  They can be simple, or very customized.  Even a simple screen in Access work and looks better than Q&Q.  For example, we converted both simple and custom forms for the County Attorney of McPherson Kansas     Price per hour: $60

Before in Q&A

After in Microsoft Access

Before - simple

Simple screen in Access

This is the default form - no charge

Before - multiple pages

Whatever takes 2 screens in Q&A can easily fit on 1 in Access

Customized Form in Access

This takes more time to do


Modern Windows Features

Check boxes, drop down lists, command buttons

Custom Queries

Before in Q&A

After in Microsoft Access

Data Entry Screen

Microsoft Access Version

Retrieve Spec (F7)

Equivalent Microsoft Access Query

The Retrieve Spec is doing as follows:

BOAT FILE Starts with RCAM
BOAT NAME contains the characters "Ultra"
ETA DATE is before 1/1/2000
BROKER TOTAL is greater than 100
BROKER NAME starts with "Harold"
PORT/ENTRY is New York
LIQUIDATED is Yes
LIQU DATE is on or after 1/1/2000
LIQU TOTAL is greater than 200

The Structured Query Language (SQL) is as follows:

SELECT CUSTBKP.boat_file, CUSTBKP.entry_no, CUSTBKP.boat_name, CUSTBKP.eta_dat, CUSTBKP.broker_tot, CUSTBKP.broker_nam, CUSTBKP.port_entry, CUSTBKP.liquidated, CUSTBKP.liqu_date, CUSTBKP.f0001, CUSTBKP.f0002, CUSTBKP.liqu_total, CUSTBKP.liquidate2, CUSTBKP.comments, CUSTBKP.help
FROM CUSTBKP
WHERE (((CUSTBKP.boat_file)="RCAm") AND ((CUSTBKP.boat_name) Like "*ultra*") AND ((CUSTBKP.eta_dat)<#1/1/2000#) AND ((CUSTBKP.broker_tot)>100) AND ((CUSTBKP.broker_nam) Like "Harold*") AND ((CUSTBKP.port_entry)="New York") AND ((CUSTBKP.liqu_date)>=#1/1/2000#) AND ((CUSTBKP.liqu_total)>200));
 

Microsoft Access Query Designer - Graphical User Interface for SQL

Simple Access default version of the above screen


Custom Reports

Also for custom reports, we can create Microsoft Access based custom reports on an hourly basis.  The cost depends on the number of details needed to reproduce the report.


Making Your Database Design Truly Relational

With Q&A, because there is basically one table per database, you were limited in your database design.  If you had customers and wanted enter a history of correspondence (for example), you had to create a large text field, or add additional fields to record what you said.   If these got filled, up, you would go to File Design and add an additional field.  This  makes if very hard to search the data later for what was said on a particular date.

A better way of designing this would be to use two tables: the CUSTOMER table, and the HISTORY table.   They would be connected by a common field, the CustomerNumber.  You can add as many records to the History table as you wish.  Some customers may have no history yet, and some may have hundreds.  This is a more efficient way of designing your database, called a Relation design.  The two tables relate to each other, based on a key field.

We can convert your "old style" design to a Relational Database design.  The cost for this varies, depending on what needs to be done.  We will provide you an estimate before hand.

See Example with names altered and masked to protect privacy of the records


Queries versus Visual Basic for Applications

If there are many Program lines in Q&A it can be tedious to convert them to Access Queries.


Q&A to VBA Program Conversion

A reason that many companies stay with Q&A for many years is that they have many complicated formulas.  We have a procedure to quickly and accurately convert all your Programming statements in Q&A to Visual Basic for Microsoft Access.  We convert all the IF, THEN, BEGIN, END, AND, OR, LOOKUP, @DATE, and other functions.  For example, here are Q&A, then using the Access field names, then the IF statement.

Q&A #1111: if #2222 <>"" then lookup(#3333, 2, #4444)

Access Query

v4444Field4: iif(v2222Field2] <>"" ,lookup([v3333Field3], 2)
VBA If Forms!fMyForm![v2222Field2] <>"" then
   Forms!fMyForm![v4444Field4] = dlookup("N2","LOOKUP","Key=Forms!fMyForm![v3333Field3]")
End If

We provide you the full program with comments
or program essentials  for simple copy and pasting into Access VB to execute with a Calc button

Q&A #1111: if #2222 ="N" then begin #3333 ="3"; #4444 ="4"; #5555 ="5"; end

Access Query

v1111Field1: iif([v2222Field2] ="N" ,begin [v3333Field3] ="3", [v4444Field4] ="4", [v55555Field5] ="5", end)
VBA If Forms!fMyForm![v2222Field2] ="N" then
   Forms!fMyForm![v3333Field3] ="3"
   Forms!fMyForm![v4444Field4] ="4"
   Forms!fMyForm![v5555Field5] ="5"
End If

more examples


Satisfied Clients
Hopewell Township, New Jersey

We converted a Q&A database to Access for the Hopewell Township in New Jersey.  This was a challenging project because their Q&A database had over 1000 fields.  We organized them in to 15 tables so they could fit the 254 field per table limitation of Microsoft Access.  This also made the database more organized and relational.  After converting the database, our instructor went to their office in New Jersey to give the staff training on the new system.

Flat file "spreadsheet" table database for DOS

Fully relational database using Windows


EpiMax in Australia


wpe14.jpg (1707 bytes)
Why is Q&A no longer supported by
Symantec?

Q&A was ahead of its time, far exceeding the ease of use of its competitor at the time, dBase II and III.   Even after over 10 years, it can accommodate more characters per text field than any other database product on the market, and more fields per record.  It has one of the only English language search functions available.

But when Microsoft came out with FoxPro and Access, it took most of the database market away.  Symantec decided to focus all its energies on the up-and-coming computer security market, offering some of the best Anti-Hacking, Anti-Spam, Anti-Spyware, and Anti-Virus utilities.

But we will still support it, or help you switch to a software that is supported by its manufacturer.


What should you convert to?

We can suggest many popular database programs, such as Microsoft Access

ODBCACT!GoldmineMaximizerAccessSalesForceSalesLogixTeleMagicNetLedger.jpg (1350 bytes)OracleOutlookPalmSharkWareGroupWiseMaestroLotus NotesWordFoxPro


Video about Q&A to Access
Youtube.com/watch?v=fsYy2aYi4pk

Q&A Password Recovery

Converting Q&A Word Processing Documents

Customizations of Forms and Reports

ConvertInformation.com

CICorporation.US

202-829-4444
800-319-3190

rickservers.jpg (120087 bytes)

.