YOU ARE HERE > HOME > Discussion Center > Discussion
Discussion Center: Discussion
Discussion: IMPORT TO EXCELL FROM WINDOWS
Author: geoff.hall@afrox.boc.com
Date: 1/8/01
Message 1 of 1:
From: geoff.hall@afrox.boc.com
Date: 1/8/01
IMPORT TO EXCELL FROM WINDOWS
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
frommonitor.gdhload;
spool off
exit
monitor.bat
Sqlplus monitor/monitor@ars01 @monitor
C:\MSOFFICE\EXCEL\EXCEL.EXE /r d:\geo\monitor.txt