At 03:07 PM 7/6/2005, David Poole wrote:
Is there, or will there soon be (Razzak), a GATEWAY IMPORT command option to specify the first row of data?
David, Ask and you shall receive! Use the OPTION FIRST_ROW nn parameter to achieve that goal. Here's how: Examples to import data starting with the second row in the CSV file. -- To replace existing table data GATEWAY IMPORT CSV filename.CSV REPLACE tablename OPTION FIRST_ROW 2 -- To append data to existing table GATEWAY IMPORT CSV filename.CSV APPEND tablename OPTION FIRST_ROW 2 Enjoy and make sure to have fun! Very Best R:egards, Razzak.
