Even better: SET NULL ' ' SET EOF OFF OUTPUT test.csv WRITE '"Column 1Name","Column 2Name","Column 3Name"' Set QUOTES=NULL SET QUOTES=" UNLOAD DATA FOR table AS ASCII USING column1, column2, column3 Set QUOTES=NULL SET QUOTES=' OUTPUT SCREEN SET NULL '-0-' SET EOF ON
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Gray, Damon Sent: Tuesday, April 28, 2009 3:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Column names on Gateway Export Karen, That's an excellent workaround. I'll use it. Thanks! ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, April 28, 2009 12:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Column names on Gateway Export For 6.5, all you can do is output to a .csv file, which will open in Excel. You would do something like this: SET QUOTES=" OUTPUT test.csv WRITE "Column 1Name, Column 2Name, Column 3Name" UNLOAD DATA FOR table AS ASCII USING column1, column2, column3 OUTPUT SCREEN Karen At the moment we're on 6.5. That's going to change, but for now...
