At 04:09 PM 12/10/2001 +0000, Paul Cheeseman wrote:
>Exporting to Excel file from Rbase 6.5++ OS Win2000 >Most annoying problem before the export a window pops >up with: >There is insufficient disk space on either the Target >drive or the Temporary File Drive. >The operation may fail. Do you wish to continue? >If yes then export continues as normal. There is Gbs' >of free space on the drive! > >Also is there any way of exporting to Excel to include >the field names(headers)? >When exporting views(with numerous fields) for statistical >analysis, in order to get the headers, I have to save the >view to a table , and list to a txt file, then into excel, >followed by export to NCSS2001. Any help to save time would >be appreciated. Paul, Try the following: GATEWAY EXPORT XLS4 filename.xls SELECT * FROM tablename Using The Glorious R:BASE 2000 (ver 6.5++), you can also use the UNLOAD AS CSV command. Example 01: OUTP FileName.CSV UNLOAD DATA FOR TableName AS CSV OUTP SCREEN Example 02: OUTP FileName.CSV UNLOAD DATA FOR TableName USING collist AS CSV OUTP SCREEN If you are planning to attend the Annual R:BASE Developers' Conference in April 2002, you'll see my presentation of exporting data with column names! Creating Dynamic Spreadsheets with Column Names! http://www.rbase.com/conference Very Best Regards, Razzak. ===================================-============================ Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-============================= ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
