General discussion

Locked

IMPORT TO EXCELL FROM WINDOWS

By geoff.hall ·
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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Desktop Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums