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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement