I just wrote this export. This method creates a clean csv file which never fails to be read by excel.
Dennis set var vfile = 'c:\temp.csv' set null ' ' set eof off out &vfile wri '"TransID","CloseDate","Cust","Target","StoreID","OrigTransID","Warr?","SR","Scode","Decription"' set quotes="""" unload data from WarrantyService + using TransID,CloseDate,Cust,CustTarget,StoreID,+ OrigTransID,UnderWarranty,ServiceRequest,FinalSCode,FinalSCodeDesc + as ascii + where CloseDate between "1/1/2007" and "12/31/2007" + and finalproblem = "sb-n" set quotes='''' out scr set eof on set null -0- ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gray, Damon Sent: Thursday, November 13, 2008 9:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Programmatically Export to CSV In 6.5++ is there a means of programmatically exporting a table to a CSV or XLS? I see I can to it through the GUI, but would like to make that part of a sproc. wwwww ( @ @ ) ------oOO---(_)---OOo------ Damon J. Gray Business System Services Anvil Corporation (360) 937-0770 oooo0 0oooo ( ) ( ) ---------\ (----) /---------- \__) (__/
