Frank You want to use altho I haven't tried it with CSV files, but it does work with ascii. R:>LOAD Loans FROM Loans.CSV USI Loan#,Principle,Interest .......
The other thing you can do is Project a temporary table then load that then append to loans. R:>PROJ TEMPORARY TmpLoans FROM Loans USI Loan#,Principle,Interest.. WHERE COUNT = 0 R:>Load TmpLoans FROM Loans.CSV AS CSV R:>Append TmpLoans TO Loans Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Frank LaVolpa Sent: Friday, August 26, 2005 6:06 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Rearrange fields during import of .csv file? Hello, everyone. I have a file - loans.csv - that I need to import into the table - loans - but the .csv file isn't in same field order as the table. How can I import it and rearrange the fields as I go? Is there a better way than using a while loop with the fetch and set ? For example: Loans.csv has: Field #1: loan#, Field #2: Principle, Field #3: Interest. Loans table is.. Field #1: loan#, Field #2: Interest, Field #3: Principle. Suggestions? A while loop will be very slow to implement for what we need. --Frank
