Hi
I am running Windows 95 and V7 of Excell
I am downloading an output file from oracle V7 and trying to load it onto a spreadsheet.
My objective is to do this automatically and use a macro to manipulate the data once in the spreadsheet.
I have read the help available and most of it deals with data coming from Access.
So far I can get the file loaded but not in column form.
It imports the data into a worksheet called Monitor.
monitor.sql
column tim format a10
set heading off feedback off linesize 300 pagesize 100
spool monitor.txt
select to_char(dat, ‘MMDDHH24MI’) tim,’,’,trans,’,’,business,’,’,uss,’,’,recursive,’,’,dml,’,’,commit,’,’,rws
from monitor.gdhload;
spool off
exit
monitor.bat
Sqlplus monitor/monitor@ars01 @monitor
C:\MSOFFICE\EXCEL\EXCEL.EXE /r d:\geo\monitor.txt