Depending on speed and perhaps this is automated. Instead of adding another sheet which would be my first answer could you not retrieve the current excel sheet in a temp table then add your new data and then export that.
Verses adding sheets. I am also not sure how mission critical time/money this is. Perhaps then you could also grab excel changes people have made etc…. Paul D From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, January 05, 2010 6:48 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: GATEWAY command Paul, Thanks for the reply. However I am exporting not importing. I should have been more clear. I have tried... GATEWAY EXPORT CSV test.txt APPEND + SELECT Controlno856, Txt1,Txt2) FROM tmp997 + OPTION MESSAGES ON + |SHOW_PROGRESS ON + |QUALIFIER &vQualifier and several variations of the above, but none work. I can create a new CSV file OK, but not append to an existing one. I can get the GATEWAY Export to APPEND using the Explorer icon, but not via a command. This will be used in an automated 24/7 program and I need to use the command line in a Timer eep. Thanks, -Bob ----- Original Message ----- From: "Paul Buckley" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, January 5, 2010 5:37:25 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: GATEWAY command Bob, >From R:Docs, try this: -- 05 append imported data in existing table starting from the second row in the file GATEWAY IMPORT CSV filename.CSV APPEND existingtablename OPTION FIRST_ROW 2 Paul Buckley From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, January 05, 2010 6:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - GATEWAY command When using the GATEWAY Icon on the Explorer bar, the option of APPEND to an existing file is present. However, I have not found the syntax for using the GATEWAY command in an EEP for this function. I.E. I need to use the GATEWAY command in an EEP to append to the end of an existing CSV file. Anyone know the syntax as I could not find it in Help.? Ver. 8 Thanks, -Bob
