At 04:58 PM 4/15/02 -0400, Bernie Lis wrote:
>I did the following: out file.xls unload data from >filename using col1,col2,col3 as csv where .... out >screen launch file.xls I got all the data but into >one cell, separated by commas. Is there a way to do >this and put the data in seperate cells? Or is there >a way to call a preset sreadsheet along with file.xls? >I can make a spreadsheet to receive the data, then >import using Excel's import, but I don't want the >user to have to do this if possible. Bernie, If you can hold on until the conference <g>, I will provide you with a FULLY AUTOMATED PROCESS (a single command file - SpreadST.RMD) to create dynamic spreadsheet(s) with column headings! . Select any database (if not already CONNected) . Select the Table/View . Select any or all column(s) . Select the sort order That's all there is to it! The Spreadsheet will be created along with appropriate column name(s) to read into MS Excel using the LAUNCH command. Of course it will be included in the conference CD. Topic: "Creating Dynamic Spreadsheets with Column Names" using The Glorious R:BASE 2000 (version 6.5++), Build:1.851xRT03 and higher for Windows. http://www.rbase.com/conference Very Best Regards, Razzak. ===================================-============================ Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase.com/events R:DCC Members: http://www.rbase.com/rdcc Developers' Conference 2002: http://www.rbase.com/conference ================================================================ 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 ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
