Ernie,

You could COPY them to a delimited text file. Then APPEND from the text file into a table with the same structure on the other end. This won't work with Memo or General fields, though.

>I need to select data from tables in my database into a cursor using an SQL-SELECT statement. I save the resulting cursor to disk for transport and import into another installation. When the SQL cursor is written to disk as a separate file, I lose all the long field names. So when I import them on the other end, I have to reconstruct the fieldnames.
>
>For example, MYTABLE.LongFieldName001, MYTABLE.LongFieldName002, and MYTABLE.LongFieldName003 becomes C_IMPORT.LongField1, C_IMPORT.LongField2, C_IMPORT.LongField3, etc.
>
>Can anyone suggest a good method or technique for bringing records with shortened fieldnames from my C_IMPORT table into the destination table, one that still has its long fieldnames?