Re: Converting Query Manager query output to Excel and Access

STRSQL
CREATE TABLE QTEMP/ODOM (MYCHAR CHAR (15 ) NOT NULL WITH DEFAULT, 
MYDEC DEC (7 , 2) NOT NULL WITH DEFAULT, MYDATE DATE NOT NULL WITH
DEFAULT) 
INSERT INTO QTEMP/ODOM VALUES('A', 1.25, '05/31/2006')
1 rows inserted in ODOM in QTEMP. 
INSERT INTO QTEMP/ODOM VALUES('B', 8.55, '05/25/2006')
1 rows inserted in ODOM in QTEMP. 
INSERT INTO QTEMP/ODOM VALUES('C', 9, '05/15/2006') 
1 rows inserted in ODOM in QTEMP. 
F3
CPYTOIMPF FROMFILE(QTEMP/ODOM) TOSTMF('/ROB/ODOM.CSV') 
STMFCODPAG(*PCASCII) RCDDLM(*CRLF) STRDLM(*DBLQUOTE) FLDDLM(',')
Start, Explorer    \\gdisys\root\rob\ODOM.CSV
A           B           C
A          1.25   5/31/2006
B          8.55   5/25/2006
C          9      5/15/2006

Rob Berendt