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
