Ernie,

What about:

CREATE DATABASE A:\TempDatabase
SELECT * FROM MyTable INTO TABLE A:\TempTable DATABASE A:\TempDatabase

Then on the other end,

SELECT * FROM A:\TempDatabase!TempTable
COPY TO C:\NewTable DATABASE C:\ExistingDatabase


>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?