Is it Excel 2000 or 2007? What flavor is it?
Can you run any macros from Excel? On/at the workstation that does this process. Sincerely, Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, January 06, 2010 8:21 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway / Append command Thanks for the suggestions, but in this case, I need to be able to simply add data to the end of a CSV file. This is being used in conjunction with EDI and has strict parameters such as end of line characters, character spacing, etc. etc. The Gateway Export command allows for some formatting options via an RGW file that are desired/needed. I tried using the OUTPUT ... AAPPEND and then UNLOAD Data. While that does append to the end of the file, I do not have the formatting options that are available in Gateway. I am able to produce the exact output needed via Gateway Export, but I cannot find the option to append an existing file. It is possible as there is an APPEND option when using the DB Explorer bar, but I need to use the command line. An interesting note... when using the Gateway Explorer bar, and you select CSV file type, check the APPEND option and then export, the file is indeed appended. However if you select the USE EXPORT WIZARD, check the APPEND option and then proceed using the wizard and export the file, it does not append. Any input on the GateWay Export line command and how to get it to APPEND to an existing column would be greatly appreciated. Thanks, -Bob
