Okay, I thought about it for 30 more seconds. Another idea:

Read through the file, and create a table with one record per variable. Make this table have the same structure as one created with the COPY STRUCTURE EXTENDED command. Then you can create your final table with CREATE FROM. You still have to populate values the same way as my previous post...


>But how to create the table to begin with? I'd have to look at everything in memory and see the type of data in the variable, the size, etc and then manually 'create cursor ...' right? I wish there was a better way! I'd like to take all variables in memory and create a table that has the same field names as the variable names (and arrays) and gather into it... oh well, I guess I was dreaming!
>
>Tracy
>
>>Hey Trace,
>>
>>The only way I can think is to LIST MEMORY TO FILE < filename > NOCONSOLE , and import the file into a table.
>>
>>>Anyway to create a temporary cursor that matches all variables in memory without knowing the variable names, type, and contents beforehand?
>>>
>>>TIA,
>>>Tracy