Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2003 Server
>>I have a text file that contains a header record and details record. How do I append the first textfile record into my table using APPEND FROM and how do APPEND FROM the remaining detail records into another table? Or is there a better way? thanks
>
>Would APPEND TYPE CSV work for you? It ignores the first record.
My file needs to be brought in as SDF actually. I think capturing my detail record through SDF will work because I can always delete the first record in my DETAIL_TABLE, however; how would I capture the first record which needs to goto HEADER_TABLE? My files are not comma seperated unforunately.
Nick
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