Switching from Q&A to Sesame2.  The input forms have been completed and I am using old data for testing purposes.  I am ready to lauch the program for the end users but I must first bring in the current Q&A data to Sesame2.  I have accessed the knowledgebase and the manuals and still do not understand how to perform this task.
Any help is greatly appreciated.

SSame fields.  No changes.

Yes. The N030911.asc data resides in the same Sesame directory as the test data.

As a still current user of Q&A, I appreciate the help to understand the Sesame database structure and uses.  The information you sent explains better than the Sesame Users Guide.
2. shows as follows:
"If the Spec Window title bar at the bottom left of your screen does not display Import followed by your form name, click on the large arrow to the right of the title until Export is the displayed spec."
Am I reading this incorrectly?  Should the Spec Window Title show Import or Export?

I opened the Q&A database, printed the database structure (as created) and the Input Form to align the fields between Q&A and Sesame.  There are Q&A fields that are not utilized in the Sesame form so, as I understand it, i'll "ignore" these fields when bringing the data over to Sesame?
When in Sesame, using the Spec Window, place the fields in the same order as the Q&A fields, then I can import the data?

I did not complete this step the first time so I have to delete all records and re-do the import?
Thanks for your patience with this switchover.

Worked great!  Had to do it a few times (mass delete and import) to get the data to carry over correctly.

Removed the Q&A fields that contained masking and changed date fields to text fields.  This removed the ()'s, & -'s, /'s to prepare the data for the import to Sesame.
I am no expert in Sesame by any means, but I think I may have the import task where I understand and can do it with the other Q&A database.

I have never had software support that has been as exceptional as Sesame.
Kudos and thanks to Ben, Raymond and the Lantica Users Forum for their help.

Becky Meier, ENP

Two quick cautions, since this will probably be a fairly popular topic:

1) Be sure to eliminate double quotes before importing.  This will generally apply only to multi-line text fields.  (We have a set of "Account History" fields.)  There are two slightly different ways to do this.  Either just use @Replace() in Q&A to change double quotes to something else (like a pair of single quotes), or replace with an oddball character such as carat and once the import is done, reverse the process to restore the double quotes.

2) There is no way to preserve hard returns using export from QA and import.  (When exporting, Sesame replaces hard returns with \n but QA doesn't.)  If you need to do so, it may be best to set up your new application (I did a conversion and then major changes to that) and then do a completely new conversion.  You'll wind up with (1) your first highly-modified conversion and (2) your new conversion with blank lines intact.  You can then export from the new conversion, since Sesame will retain the blank lines.

Regarding the Sesame export-import, it won't matter if the fieldnames from your new translation don't match the fieldnames of your first conversion (now significantly modified) because Sesame doesn't use fieldnames in the export-import process.

Great news!  I'll give it a try.
Sure would be a great weekend if I can do this properly and it works.