Frank,
Create a temporary view with column names in the order of loans.csv. Then use "LOAD tblview FROM filename AS CSV" syntax.
Jim Bentley
Frank LaVolpa <[EMAIL PROTECTED]> wrote:
Frank LaVolpa <[EMAIL PROTECTED]> wrote:
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
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
Start your day with Yahoo! - make it your home page
